Combining two crosstab queries You must specify one or more row headings, one column heading

[vba317]

In Access 2003. I have two crosstab queries that are working. To create the report that I need to create I need to combine them. I keep on getting the error to create a crosstab query, you must specify one or more Row headings,one Column heading and one value option. Is there a way around this error? I need the units in column 1 and RVU in column 2

Tom

Query 1 for RVU
TRANSFORM Sum(dbo_tmp_rpt_dat_CPTRVU.workrvu) AS [Total Of workrvu]
SELECT [cptcode] & "-" & [cptcomp] AS CPT, dbo_tmp_rpt_dat_CPTRVU.cptdesc, dbo_tmp_rpt_dat_CPTRVU.unitrvu
FROM dbo_tmp_rpt_dat_CPTRVU
GROUP BY [cptcode] & "-" & [cptcomp], dbo_tmp_rpt_dat_CPTRVU.cptdesc, dbo_tmp_rpt_dat_CPTRVU.unitrvu
PIVOT dbo_tmp_rpt_dat_CPTRVU.rptpd;

Query 2 for units
TRANSFORM Sum(dbo_tmp_rpt_dat_CPTRVU.adjunits) AS [Total Of units]
SELECT [cptcode] & "-" & [cptcomp] AS CPT, dbo_tmp_rpt_dat_CPTRVU.cptdesc, dbo_tmp_rpt_dat_CPTRVU.unitrvu
FROM dbo_tmp_rpt_dat_CPTRVU
GROUP BY [cptcode] & "-" & [cptcomp], dbo_tmp_rpt_dat_CPTRVU.cptdesc, dbo_tmp_rpt_dat_CPTRVU.unitrvu
PIVOT dbo_tmp_rpt_dat_CPTRVU.rptpd;

 

[PHV]

Did you see this ?
faq701-4524

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[vba317]

Thanks I will try the suggestion