[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