date/ time type query

[NWLPM]

I am a beginner MS Access user and need to write a query that will
extract records that are older than 30 days.

[Robert]

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