Selected Days Filter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to filter my data to return information for a specified date and for
the previous 14th Day, 28th day, etc for the previous 6 periods. i.e.

28/11/06 data
14/11/06 data
31/10/06 data
17/10/06 data
3/10/06 data
19/9/06 data

Any suggestions for a criterea (Or other method) to acheive the above would
be gratefully recieved

Thanks in advance

Simon
 
Build a table named CountDown with a field called Num. Add records
containing 0, 2, 4, 6, 8, 10.
Create a query using your data table and the table named CountDown but do
not join.
Use this as criteria on your date field --
DateAdd("w", -[CountDown].[Num], [Enter specific date])
 
Many thanks Karl, worked a treat.

Regards

Simon

KARL DEWEY said:
Build a table named CountDown with a field called Num. Add records
containing 0, 2, 4, 6, 8, 10.
Create a query using your data table and the table named CountDown but do
not join.
Use this as criteria on your date field --
DateAdd("w", -[CountDown].[Num], [Enter specific date])


Simon One said:
I want to filter my data to return information for a specified date and for
the previous 14th Day, 28th day, etc for the previous 6 periods. i.e.

28/11/06 data
14/11/06 data
31/10/06 data
17/10/06 data
3/10/06 data
19/9/06 data

Any suggestions for a criterea (Or other method) to acheive the above would
be gratefully recieved

Thanks in advance

Simon
Click to expand...
Click to expand...
 
Back
Top