Automatic date for query (1 Viewer)

[Parker]

I would like to have a query, based on a table, displaying continuously, using the system date and displaying results based on 24hrs before & after the system date

I'm sure, I think it must be posible but I don't know how.

The reason for this is so that the user has a constant display of work in progress for the present day, the prievious day and the following day.

If it is possible to acieve this it would also be nice if this query would automaticaly update both on additons to the underlying table and on a change of system date.

Our booking screens display 24/7 and some of my end users are not the brightest bulbs in the pack! Experiance dictates that if you expect them to do something as basic as manually update a query like this then they either won't do it or else they'l find a way to mess it up so they can give the classic excuse of "the computers are down"!

Any ideas?

Thanks

 

[Rich]

Between Date()-1 And Date()+1

 

[Parker]

Thanks Rich

So I asume from this that Date() calls the system date

 

[Rich]

yes

 

[Parker]

Thank you