Dates

[lead 27]

Hi everyone

I am tring to create a query so that when I click a command button I can get all the records that have a date between now and the next 7 days.

the reason why I want this is because my DB is a servicing schedule and I want to be able to click the button and have a list of all items due servicing over the next week. I would do this on a friday.

Any ideas

 

[lead 27]

Just had a thought a box where you could put the date into would probabily be a better idea

i.e. you click a command button which displays a msg box taht you can put a date into then the query will show a report with all teh items with a date before that one

 

[CraigDolphin]

In the field that stores the dates try using a criteria of

Between Date() AND DateAdd("d",7,Date())

 

[CraigDolphin]

for the second variant...
use a criterion of:

<=[Input Maximum Date]

and define the parameter [Input Maximum Date] as date/time (Design View Menu>Query>Parameters)