Crosstab Query Based on Crosstab??

[cokeblue8]

Hi all, I am utterly unsure if what I want to do is even possible:

I have two crosstab queries, qryRewCOCredit and qryWrapCOCredit which show the changeover (CO) times for the specified machine when they are NOT zero. (all zero entries don't show up).

There are many cases when there is a CO for the Rewinder on a specific day, but not for the Wrapper, and vice versa.

I want to make another crosstab query which performs a calculation. To keep it simple:

If (RewCOCredit>WrapCOCredit) Then
5-RewCOCredit
Else 'WrapCOCredit>RewCOCredit
5-WrapCOCredit

Please help!!!

 

[Guus2005]

Dont believe it can be done since rows and columns are switched. You could use a temporary table to store your crosstab data and query that!

 

[cokeblue8]

hey guus thanks for the reply

i've been mucking around with it, and it seems like i'm getting somewhere- since the crosstabs are based on select queries, i'm seeing if i could do everything with the select queries, and THEN make a big crosstab at the end.