show records 1 day in advance

[jasone]

Hi,

I am about to create a system which will alert the user of any orders which need to be processed a day in advance:

is there a simple query to show all records in a table 1 day befor the actual date?

Regards

Jason

[Umoja]

Hi Jason,

I don't understand completely the system your are trying to build but try the following. In the query under the date field, in the criteria enter

=Date() + 1

Hope this helps.

[missinglinq]

Umoja has the right idea, but people far wiser than myself warn against using the Date() +1 syntax, as they feel it will be phased out in future versions of Access! In Query Design View, make a query from your table, including the appropriate fields, and in the Criteria for the order date field, enter this:

DateAdd("d",1,Date())

You can then use the query as the Record Source for a form, or run the query thru code, and it will return only records whose Order Date is the next day.

Linq ;0)>

[jasone]

Many thanks to both of you!

such a simple query.... but i just couldnt work this one out :-)

Thanks !

[missinglinq]

Glad we could help!

Linq ;0)>