[AccessD] Counting Co IDs

I would probably do two queries, one to select and to possibly group
and the second that uses the first as it's input that counts.

GK

On 11/1/07, Bob Heygood <bheygood at abestsystems.com> wrote:
> 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
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


-- 
Gary Kjos
garykjos at gmail.com