Criteria for totals query

T

TheVadek

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
 
M

Michel Walsh

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
 
T

TheVadek

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...
 
Top