below is my sql and I keep getting this error "Run time error 3075" I tried everything that I know, but nothing works. HELP Please!

strsql = " SELECT tbl_Main_Quality.Analyst_Userid,tbl_Main_Quality.A ccount_Number, tbl_Main_Quality.Date_Reviewed" & _
        " FROM tbl_Main_Quality " & _
        " WHERE tbl_Main_Quality.Analyst_Userid='" & strtxtAnalystUserid & "'" & "AND tbl_Main_Quality.Account_Number='" & strtxtAccountNumber & "'" & "AND (" & "#" & Date & "#" & "-[Date_Reviewed)>=" & Strdate & ""

Hey,

Two things I noticed:

"[Date_Reviewed)>=" should be "[Date_Reviewed])>="; you are missing the end ]

And & Strdate & "" should be & "#" & Strdate & "#"

Because you are comparing a date.

Brian

No, Brian, not quite. It looks like strDate is not a date but the DIFFERENCE between today's date and Date_Reviewed... i.e. a number.

Try this, Setyna... oh, and by the way... WELCOME!

strsql = "SELECT [Analyst_Userid], [Account_Number], [Date_Reviewed] FROM tbl_Main_Quality" & _
" WHERE [Analyst_Userid] = '" & strtxtAnalystUserid & "' AND [Account_Number] = '" & _
strtxtAccountNumber & "' AND " & DateDiff("d", Date, [Date_Reviewed]) & " >= " & Strdate

If strDate is indeed a number, you should not start it with the letters "str" because to me that means it's a string (text). If it is text then the last part should read

" >= '" & Strdate & "'"

Also, from your SQL, strDate looks like a number; but from your naming it looks like it could be a string or a date. If it's a number difference, call it something lngDaysElapsed or something like that.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Oh, and I never remember which date goes where in DateDiff so you may have to swap the dates to get a positive number. That is, change

DateDiff("d", Date, [Date_Reviewed])

to

DateDiff("d", [Date_Reviewed], Date)

or

Abs(DateDiff("d", Date, [Date_Reviewed]))


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Thanks SerranoG...It's working now.yea strdate is a number..oops!