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.

Nov 12 '05 #1

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

Nov 12 '05 #2