How to Show All 30 Days or Older

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

Guest

I'm brand new to Access. This should be an easy question for many here. I'm trying to create a query that shows me all records that have a IssTskDate that is older than 30 days from the day the query is run. How do I put that in the Design View of the Query Editor

I have tried every combination I can think of? Is it an expression in the Criteria for the IssTskDate field? Is it a new expression? And how does one code the expression? I've tried [IssTskDate]<(Date()-31), but no luck

Thanks for your help. This is a class assignment.
 
Setting the criteria under IssTskDate to
<Date()-30
should work.
What results do you get when you try this. When you state "but no luck", it
doesn't give us much to go on.
--
Duane Hookom
MS Access MVP


Deb said:
I'm brand new to Access. This should be an easy question for many here.
Click to expand...
I'm trying to create a query that shows me all records that have a
IssTskDate that is older than 30 days from the day the query is run. How do
I put that in the Design View of the Query Editor?
I have tried every combination I can think of? Is it an expression in the
Click to expand...
Criteria for the IssTskDate field? Is it a new expression? And how does one
code the expression? I've tried [IssTskDate]<(Date()-31), but no luck.
 
"No luck" meant I got all records regardless of date. I've re-entered using your syntax and it works perfectly

Thanks.
 
Back
Top