Criteria for totals query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Have a query w/ totals button turned on.

in the criteria row of my date field I want to limit the query results by
specifying give me all the records that are no more than 30 days old or don't
have a date.

I tried
= now()-30 or is not null
Click to expand...

Access converts above into
= now()-"30" or is not null
Click to expand...

I get no results back.

any suggestions?

Thanks
 
You "date_time" field is NOT a string (text), isn't it? It should be
date_time, as data type, as seen from the table design view.


Hoping it may help,
Vanderghast, Access MVP
 
damn i feel stupid...thanks mike

Michel Walsh said:
You "date_time" field is NOT a string (text), isn't it? It should be
date_time, as data type, as seen from the table design view.


Hoping it may help,
Vanderghast, Access MVP
Click to expand...
 
Back
Top