hi everyone... i need to ask someth

[CompGirl]

hi everyone... i need to ask something.. is there a way to put three crosstab querys together.. lets say ive a crosstab query that look something like this

risk class severity class
I II III IV
a 2 1 2 3
b 8 5 4 1
c 1 2 8 6
d 3 5 6 6

and i have three of these because every product (ID) has its own risk within environment, human and property... now i have made three different query based on this... but i want one that will "sum" these in to one.. is this possible? and if it is, how can i do this?

 

[fredk]

You say there is a product id field but you did not show that in your example. can you show me exactly what your data looks like? Also, elaborate on "every product (ID) has its own risk within environment, human and property"

Fred