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?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER