Counting the number of returns from a query

[interspectrum]

I use access to make our sales appointments. We collect the customer's
personal information such as address and telephone numbers. Each
appointment is assigned a unique appointment number. This field is
Appt_Number and it is set by the autonumber data type. I also have a
DateTaken field. This is the date we recorded the record for the
appointment.

I need to be able to run a query to tell my how many appointments have
been made in a given week, month, and year. An example would be how
many appointments where made from Jan 1 2006 to Jan 7 2006, or in the
month of December 2001.

I can make a query that gives me the results for those dates, but I can
not figure out how to count the number of results. I have googled and I
have searched access's help. All the examples are for counting several
different rows or from several different tables.

I am sure this is a simple task but I need help and would be greatfull
for any assistance.

 

[Dave K]

Hi,
Create a query and add to the grid of the query all the information you
would like to extract (I.E. Appointment date, customer name)

Once appointment date is added to the grid, type in the criteria section
under that:
Between [Enter Start Date] and [Enter End Date]

Then select totals from the top menu, and using the drop down under customer
name (labeled totals) select count.

This is in the simplist form a count of customer names between 2 dates. You
could try adding more to the query grid to gather further information I.E.
Salesman or customer advisor, this would then give you the count of customer
names against a specific salesman between 2 dates.

HTH
Davey