multiple crosstab in report

I have been trying to create a report based on several queries. The first
query is a crosstab that gives me counts by state and color. from that
crosstab, I have create and a 2nd and 3rd query which calculates a percentage
based on the total count from query 1. Each query works fine by itself and
even with 2 queries together. When I add the 3rd query the results are
incorrect. I'm thinking the query is taking the first total and calculating
from that rather than by each color. I'm trying to obtain these results

Species Total Blue
Brown Yellow Gray
State1 15 7
3 2 3
(calc of local% of color based on
# in ea column)
(calc of local% of color based on
# in ea column)
State2 12 5
0 4 3
(calc of local% of color based on
# in ea column)
(calc of local% of color based on
# in ea column)
I'm trying to place the final result in a report that looks like the above.
I've tried to create an unbound report, changing the source to each separate
query but the report keeps giving me an error# or name? message. I've tried
subreports, but I want the entire report merged together by state rather than
separate reports within each other.So I'm back to figuring out why the query
displays incorrect calculations. Any thoughts on what is the best approach
to this?

I forgot to add that each group of information is based on a species within
the state (which is calculated by the 1st query) such as VA could have a
row with Dog, Cat, Cow and DC could have on Dog and Cow. Then the caluclated
columns

"Mpower" wrote:

I have been trying to create a report based on several queries. The first
query is a crosstab that gives me counts by state and color. from that
crosstab, I have create and a 2nd and 3rd query which calculates a percentage
based on the total count from query 1. Each query works fine by itself and
even with 2 queries together. When I add the 3rd query the results are
incorrect. I'm thinking the query is taking the first total and calculating
from that rather than by each color. I'm trying to obtain these results

Species Total Blue
Brown Yellow Gray
State1 15 7
3 2 3
(calc of local% of color based on
# in ea column)
(calc of local% of color based on
# in ea column)
State2 12 5
0 4 3
(calc of local% of color based on
# in ea column)
(calc of local% of color based on
# in ea column)
I'm trying to place the final result in a report that looks like the above.
I've tried to create an unbound report, changing the source to each separate
query but the report keeps giving me an error# or name? message. I've tried
subreports, but I want the entire report merged together by state rather than
separate reports within each other.So I'm back to figuring out why the query
displays incorrect calculations. Any thoughts on what is the best approach
to this?