Show records for the past 30 days

[borris]

hi there,

is it possible to build a query that returns records for the past 30 days.
can this be done in query by design or is more of a sql thing?

i'm not quite sure how to do this so any help is much appreciated.

thanks for your help

 

[Allen Browne]

In the Criteria row of the query design grid, under your date field, enter:

 

[borris]

In the Criteria row of the query design grid, under your date field,
enter:

thank you. i'll give that a try tomorrow at work.

thanks again.