Query with 2 inputs

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Here is the requirement: Ability to enter start time and end time to produce
a report/query that displays only transactions that fall within that time
frame. And also a query to return the number(count) of transaction within
that time frame.

The input forms requires a time to be entered, so time is available in the DB.

Here is what I've tried: The field that contains the time - I have placed 2
times in the query and in criteria I typed [Enter the Start time:] And [Enter
the End time:].
I tried the <= and >= but I am still not a programmer and this query may be
out of my league. Any help would be great. I will continue to review the 3
books I have for reference. Thanks!
 
Between [Enter Start Time] And [Enter End Time]

It may be best to open the Parameter dialog box and specify that the
parameters are of type date/time, so as not to be interpreted as text.
 
Back
Top