By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,247 Members | 1,989 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,247 IT Pros & Developers. It's quick & easy.

date/ time type query

P: n/a
I am a beginner MS Access user and need to write a query that will
extract records that are older than 30 days.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
nw***@yahoo.com (NWLPM) wrote in message news:<c0*************************@posting.google.c om>...
I am a beginner MS Access user and need to write a query that will
extract records that are older than 30 days.


this is pretty but it works for me...

Field: 30DayRecords: DateDiff("d",[YourDateFieldName],Date())
criteria: >30

Hope this helps,

Robert F
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.