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.
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.