Prompt User for Date Range when running QUERY

[taimysho0]

hello, i have a date column (which also has the time of day included), when the query runs, i want the criteria set up so that it will prompt the user to enter the date range that he or she wants to look up

i think its something along the lines of thjis in the criteria field:


between [date range] and [date range]

[jzwp11]

You are basically correct but you have to have two different parameter names

...BETWEEN [DateFrom] AND [DateTo]


I typically use an unbound form with two textbox controls and a button. The two textbox controls would be for your dates of the date range. You would use the command button wizard to set up the button such that the query is run when the button is clicked. This way your users never have to guess which query to run.

[taimysho0]

how would i do this without creating a form? when the user clicks on the query i just want it to prompt the user on click, then the rest of the query will run to pop a table


also, would i need two columns then with identical data? one column for date to and a second for date from?

or does it just require ONE date column? currently i only have one date column called [event date] for example

[jzwp11]

The ...BETWEEN [DateFrom] AND [DateTo] would be the criteria for the event date field. The [DateFrom] and [DateTo] are 2 different parameters.


The query (in SQL text) would look something like this:

SELECT field1, field2, etc.
FROM yourtablename
WHERE [event date] BETWEEN [DateFrom] AND [DateTo]


You do not have to use a form, but I suggested it since it might be easier for your users. In general, your users should have have access to your objects (tables, queries etc.) All user interaction should be through forms you provide for them.