[AccessD] Counting Co IDs

Bob Heygood bheygood at abestsystems.com
Thu Nov 1 11:28:03 CDT 2007


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.










More information about the AccessD mailing list