Query Criteria

[Guest]

I'm trying to create a query that takes all the records that were made on a
date inputed by the user. How would I write the query criteria such that it
would ask the user for a date and then collect all the records with that date
from a different query or table.

Thanks,
Keith

 

[Guest]

hi,
depends on what date format you have.
if the date is just mm dd yy, you would only need to enter
the date desired in the criteria pane.
if the date is mm dd yy hh mm ss or similar you would have
to set up a date range

 

[Guest]

I usually recommend that when you have independent user input use unbound
fields on a form to hold the data the query uses as criteria. For instance,
you have a form frmReportMenu. Create two unbound fields, BegDate and
EndDate. Then on the criteria line of your query, under the date field, you
would have
Between Forms!frmReportMenu!BegDate and Forms!frmReportMenu!EndDate

Then have a button to run the query or report from that same frmReportMenu.

You can do something similar for the user Id.

Hope this helps.

 

[Guest]

Works great, thank you.