Hi, I'd appreciate any help on the following:

In a Form I have the option of entering say 1.1, 1.2 ...1.12 in 7 different fields. My problem is that I need to do a count/sum on all of the 7 fields for each particular occurrence ie the 7 fields are listed A-G and there could be 3 occurences of 1.1, 1 of 1.2 and null in the others. I need this summary to filter thru' to another table depicting that for those 7 fields there was 3 occurences of 1.1 and 1 of 1.2. I've been able to do a simple query thru' QBE window which allows me to count for 1 occurence but not more as I've used the OR criteria to pick up each occurence of say 1.1 in A-G etc.

I think I'll have to write a more complex query in SQL but don't have any notion how to do this.

Hope this makes sense to someone - it's difficult to explain!

Thanks

Because your table design is not normalized, you will need to write 7 queries. One for each field.

Your table appears to be designed as a spreadsheet. Those 7 columns should most likely be stored as 7 rows in a new table.

Thanks for your help

it works fine now.