Microsoft Access User input Query

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!
Thanks

Then you will also need to set these other properties:
BoundColumn: 1 'this is on the data tab of the properties dialo
ColumnCount: 2 'this is on the format tab
ColumnWidths: 0, .75 'also on the format tab

When you view the combo in form view, with these settings, you should see "Days" or "Months" displayed. But when you reference the combo box in your query, the DateAdd( ) function will see "d" or "m", which are valid parameters for that field.

It would help us if we could use the correct names of your form, controls, and fields. This will prevent you from having to translate the examples we give you into the proper syntax for your form or table. Can you post the SQL you currently have? Change the view from query design view to the SQL view and copy the text.

Note that in the DateAdd function you will need to replace "yourFormName" with the name of the form you are using to enter the period type and # of periods. You will also need to replace "cbo_PeriodType" and "txtNumPeriods" with the names of the controls on your form.

Yes, to make sure your users don't enter incorrect data, the best way to do this is to create a form with the combo box and textbox to enter these values. Then add a command button that will run the query based on the values in those controls. But for testing purposes, you could start out by replacing:

The expert was great to help me solve my problem! As I am unfamiliar with the software they were very helpful in ensuring I understood and took me through the steps
I am very grateful and would recommend to others
Excellent - thank you!!

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.

Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…