Help with how to run query using dates and numbers both

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

Guest

I am new at Access; just completing a college course. I am trying to run a
query that will locate specific dates (mm/dd/yyyy) and specific numbers (# of
clients). The only help I have is my textbook. It was great for lessons but I
can't find any help on how to do both of these for the same query. Is anyone
out there who could help...and be very basic? Thanks so much.
 
vschwert said:
I am new at Access; just completing a college course. I am trying to
run a query that will locate specific dates (mm/dd/yyyy) and specific
numbers (# of clients). The only help I have is my textbook. It was
great for lessons but I can't find any help on how to do both of
these for the same query. Is anyone out there who could help...and be
very basic? Thanks so much.
Click to expand...

The graphical query builder has a multiple criteria rows (and you can add
more than what is there by default).

When you place multiple criteria on the same criteria row they are ANDed.
When you place multiple criteria on different rows they are ORed.

If you want AND criteria then just put the criteria you want for the client
numbers underneath the client number field in the grid and (on the same
criteria row) place criteria for the desired dates underneath the date field
in the grid.
 
Back
Top