[AccessD] count Types query (A97)

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: