Between Two Dates - One Parameter Query and one DateAdded

[mkx]

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.


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

[June7]

The only option would be a dynamic parameterized query - I NEVER use them.

SELECT * FROM table WHERE [date field] BETWEEN [enter date] AND [enter date] + 4;

[mkx]

Would it be better to do the date addition straight in a report instead? Or would it still require the date ranges to be specified in the query?

[mkx]

Never mind I was able to figure it out. Thank you for the help though!