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.