Can someone help?

I need the code for a filter or query which will show the past x (12, 24 etc) months worth of data. Each record has a date tag so i need a filter which will just show records for say the past 3 months.

Any ideas?

How do you want the user to select the number of months worth of records?

In the QBE, for the query, under the date tag field, place in the criteria row a >=DateAdd("m",-x,Date())

Where x is the number of months

That works really well thanks.

Ideally i'd like to use a pop up form to enter the number of months. If I no one can help me with that then i'll just use a series of preset queries.

Chris -

Read-up on Parameter Queries. Here's a simple example you can try (substitute your table and field names).

PARAMETERS x Short;
SELECT tblDevProcess.*
FROM tblDevProcess
WHERE (((tblDevProcess.startTime)>=DateAdd("m",-[x],Date())));


Bob

Thanks. Wow I love Parameter queries!