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