Hello,

I am trying to do a query where I ask the user for a date, and then get the results for all the records with that date plus the records that have a date up to the next 4 days that the user entered.

For example, once the query is run the User will be asked to put in a date and they enter 06/29/15. The query will then add 4 days to it to figure out the end date which would be 07/03/15 and show all the records that have a date from 06/29/15 up to and including 07/03/15.

Any help would be greatly appreciated. Is this even possible without using VBA or macros?

---

Reply from Richard Rost:

You can't specify default values for simple query criteria.

However, you could make a little form with two date values on it, and then an AFTERUPDATE event for Start Date could update End Date for you.