[AccessD] Counting Co IDs

Bob Heygood bheygood at abestsystems.com
Thu Nov 1 15:12:32 CDT 2007


I think that that will just "count" the CoIDs, I want to know how many
different ones are represented. 
One of the issues is I won't know before hand how many to allot for....

I may not be doing a good job of defining this either....

TIA

 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Thursday, November 01, 2007 1:04 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Counting Co IDs

Totals view will do the trick, use the Count aggregate. That will return
just the one value though. If you need additional details, you'll need a
subquery.

Susan H.

> What I need is to count the number of companies.
> It is the last piece of data in my example that I am looking for.
> How many different companies responded to the question and many yes 
> and how many no.

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list