Date query problem

[Whitebait]

Hi,

I'm pretty new to access databases, and queries in particular. I have a table with details of these employees for a company, and each employee also has a special date as an attribute. I want to make a query that shows the employees that are currently one month (30 days) from being at that date.

So if someones date is the 4th of November, I want the query to return their details if that query is run at the 5th of October. Basically so I have one month to sort out things that have to be processed by that date.

Any help is much appreciated.

Alex

 

[Crispy]

In the criteria for the date field, type >Now() and <=Now()+30

This should return all the records within 30 days of today's date. However your date field will have to have a year element not simply a date and month.

 

[Whitebait]

Thanks, that works great.


One other thing, is there any way I can get Outlook to automatically run the query and return it's results in any way at all? I know it's a long shot, but would be quite handy if it could.


Thanks for your help.

 

[Crispy]

When do you want the query to run? Do you want the user to click a button and run it, or do you want it to run at a particular time / date etc?