Instead of using [] to ask for input in which the user can enter today's date or today's date plus 1 day how could I have it automatically choose the current date or add 1 day to the current date and return records for those days?
Instead of using [] to ask for input in which the user can enter today's date or today's date plus 1 day how could I have it automatically choose the current date or add 1 day to the current date and return records for those days?
so in design view in the criteria box I just have to enter "=Date()" or =Date() + 1 ?
Thats too simple LOL. Thanks.
Whats the best method to have this query run daily on its own?
My tendency would be to create a db that does what I want and run it from Windows Scheduled Tasks.