[AccessD] count Types query (A97)

Ahhh...I forgot about the totals option in queries...I never need to use
it...never until now anyhow. I think this is the beginning to me
figuring this out. I already popped it in and it worked for a total. I
also made one that counts each by office location. I'm going to try to
place them into a report together somehow, and I'll basically be
finished.

Thank you very much!

Now, I gotta get ready to leave and take my daughter to get some tree
frogs for her birthday...and I'm not weighed down by any problems!

Thanks Again!

Take care...have a great weekend everybody!

John W Clark

>>> Jdemarco at hshhp.org 03/07/03 12:51PM >>>
In the query grid add the name column and create concatenated field
called MakeModel (unless they're already one field; can't tell by the
listing). Turn on Totals and set the Name field to Count, MakeModel to
GroupBy.

HTH,

Jim DeMarco
Director of Product Development
HealthSource/Hudson Health Plan


-----Original Message-----
From: John Clark [mailto:John.Clark at niagaracounty.com] 
Sent: Friday, March 07, 2003 12:21 PM
To: accessd at databaseadvisors.com 
Subject: [AccessD] count Types query (A97)


How do I limit a query to list one of a type and count its occurrances
in a table

EXAMPLE: