[AccessD] Totalling numbers from a multiple entries in two fields

tblMain has 7 ethnicity options in the one field [Roots]. Each of the
options involves 10 or so different jobs [Work].

I have to find the numbers for each of the Roots options for each job
[Work].

I tried with a number of queries which I pasted bodily into Word to make an
instant report. But  some strange results is the consequence. 

Be very pleased to hear how an expert would go about it. 

Cheers paul  





---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.773 / Virus Database: 520 - Release Date: 05/10/2004