Make Table in Access 97 date conversion error

[MyNeckHurts]

I'm getting an error: "Function isn't available in expression in query expression 'dbo_RMS_Roll30DAY_SALES_EXCH_DLY.TXN_DT between date()-7 and date() and dbo_RMS_Roll30DAY_SALES_EXCH_DLY.DRCT_FLFLL_FLG = 'n'".

If I remove the date() it returns data.

Thanks!

 

[PHV]

Have you tried to play with Now() ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[MyNeckHurts]

Thanks PHV, Now() does work. I'm not sure why I didn't try that to start with.