[AccessD] Counting Co IDs

Thanks for getting back to me.

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.


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 9:47 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Counting Co IDs

Have you tried a Totals view?

Set JID to GROUP BY and use SUM on the columns you want to total.

Susan H.


> Hello to the list,
>
> I have a table which contains records each of which have a CoID 
> (Company ID), a JID (Job ID) and some responses to questions; some 
> Boolean and some currency.
> It is a requirement for me to create a query for a report.
>
> A problem I have run into is I need to provide a count of companies 
> that had a response to a question grouped by JID. Like:
>
> JID Question Num Companies
> Answer Responding
>
> 2 Q1Yes 3
> 2 Q1No 5
> 3 Q1Yes 9
> 3 Q1No 7
> 5 Q1Yes 31
> 5 Q1No 74
> 8 Q1Yes 3
> 8 Q1No 0
>
>
>
> Seems like I could get this from some SQL Totals Statement/Query.
>
>
>
>
>
>
>
> --
> 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