Query summary

lyatri

Registered User.
Local time
Today, 09:15
Joined
Dec 6, 2012
Messages
14
In my table/form I have 4 yes/no tick boxes. I have built a query which counts how many boxes are ticked in each record then another which summarises them and tells you how many records have 4 boxes yes how many 3 yes etc.

On the same table/form I have 4 corresponding combo boxes with around 5 options (all the same options). I would like to build a query which adds up how many of each option from the lookup was selected accross the four boxes in a record and then I assume another which will then summarise each category accross all records.

I then want to put all this on the same report. I currently have a report which works for the first part.
 
Can you provide sample data from your table (and I mean table, not form) along with what you expect the query to return based on that sample data?
 

Users who are viewing this thread

Back
Top Bottom