Microsoft Access User input Query
Posted on 2013-12-26
I need to create a query in access to display an invoice for future events
I need the user to input how far ahead they would like to display the results, so far I have that the user inputs the amount of days ahead they would like using:
Between Date() And [End Date]
This works fine at the moment but what I actually need is to ask the user if they want days or months and then enter how many days/ months they want to see what parties they have up until that day/month
I have been trying to work this out for a few days but no success - if anyone could help would be greatly appreciated!