querie grouping

[rmceuen]

I am trying to group based on multiple criteria and also count.

[cisid][taxid][paper][prod][lob][owner][add][city][state][zip]

I have multiple queries TABLE----[tax id] [paper][prod][count prod]
Table and querie above [cis id] [ tax id] [count tax id]

from here I cannot take the individual queries and combine them with to match up under the cis id.

goals are.....

1. match up taxid prod and paper and find how many tax ids under each cisid with matching criteria of paper and prod only---- all other fields are not grouped but will be listed
2 report to show 1 cisid with 1 each taxid under the cis with paper type under this listed once and prod listed under each

Results to show How many tax ids have all the same criteria(paper)(prod) under each cis id without showing duplicates in the report

this is what I am trying to do for my final report

cis id tax id paper lob


lob
lob
paper lob
lob
tax id paper lob
lob
cis id tax id paper lob etc.......

Any help is appreciated.

[June7]

Does the second query end up with multiples of the taxid because of grouping on cisid?

Might need to be report/subreport arrangement.