Link to home
Start Free TrialLog in
Avatar of zrancidr
zrancidr

asked on

Access query that uses a dynamically created date

I apologize if the question title wasn't appropriately named, but it was hard to try to come up with the words.

I want to create an Access query that deletes any record in a table that is older than 30 days ago from the current date.

I'm familiar with writing SQL statements, but not one that would use a variable type element as with this example.

Is there a way to do this in Access?
ASKER CERTIFIED SOLUTION
Avatar of jmoss111
jmoss111
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of zrancidr
zrancidr

ASKER

I should have just gone ahead and tried to do that myself...that was my initial inclination.  Thanks!!