Peeps whats up with this code and cant see where its gone wrong ne one ne ideas???
WHERE ((Int_Fault.Job_Done)=True) AND ( Int_Fault.Date_Resolved BETWEEN #" & DateAdd("m",-1,Date) & "# AND #" & Date & "#)
all I want is for access to return date between todays date and the date one month prior.
I just get bombed out with syntax errors .