monthly overdue cases

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

Guest

I'm new at writing queries. I need a query that will return cases more than
30 days old every month. The line I wrote was : <Date()-30
I'm getting incorrect returns. Any suggestions would be appreciated.
 
The criteria you have is correct. What "incorrect returns" are you getting?

Maybe the date field is not a DateTime datatype. Are you sure it isn't text?

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
(Currently in Japan)
 
I'm getting back cases that are less than 30 days old. The datatype is set to
DateTime, that was the only thing I initially knew to check. Any ideas would
be appreciated. Thanks.
 
Missa,

Can you post the SQL? Open the query in design view, then from the View
menu, select SQL View. Copy the entire SQL and post it here.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
(Currently in Japan)
---------------------------
 
Back
Top