Access Queries - Date

[jlyn123]

Hello,

Is there a way to be prompted in parameters to only enter one date when trying to run a query. I can only find that the date range works to bring up data. This relates to a time study database that has been created and running reports on specific users. For certain criteria I only want to see on one user on a certain day. It will not always be the same day or the prior day or current day info. There maybe requests for any particular day of the week or month.

Any help would be greatly appreciated.

Thanks

 

[Joe4]

It is pretty easy to create a Parameter Query with a single date.
See here: https://support.office.com/en-us/ar...-reports-8209eb5c-1589-42e2-9b20-4181f4c7a356

If you are having issues, post the SQL code of your query (change query to "SQL View", and copy and paste code here), and explain the the issue in more detail (provide example data, if it helps in your explanation).