HI THERE:
I have a CROSSTAB query.
Query1:
TRANSFORM Sum(tab_us_ovs.US_CAR_TOT) AS SumOfUS_CAR_TOT
SELECT tab_us_ovs.PROVCODE, tab_us_ovs.MONTH, Sum(tab_us_ovs.US_CAR_TOT) AS [Total Of US_CAR_TOT]
FROM tab_us_ovs
WHERE YEAR=1992 OR YEAR=1993
GROUP BY tab_us_ovs.PROVCODE, tab_us_ovs.MONTH
PIVOT tab_us_ovs.YEAR;

PROVCODE---MONTH---1992---1993
3000------------3------100----200
2000------------4------300----400

Query 2:
Can I ref to the Last 2 fields of this CROSSTAB query in my 2nd query.
After EVERY 3 months, we have to change the year like: YEAR=2000 OR YEAR=2001
I was trying
Select Query1.column(3) from Query1;
----Not working. What is the correct query expression