Combine Crosstab Queries?

  • Thread starter Thread starter AGOKP4
  • Start date Start date
A

AGOKP4

Hi,

I'm trying to combine 3 crosstab queries, the SQL statements are below and
get a report out of it. Is it possible to do it this way or try something
else?

Thanks

TRANSFORM Count([Enrolled Qry].[Study ID]) AS [CountOfStudy ID]
SELECT [Enrolled Qry].[Creatinine Group], Count([Enrolled Qry].[Creatinine
Group]) AS [CountOfCreatinine Group]
FROM [Enrolled Qry]
GROUP BY [Enrolled Qry].[Creatinine Group]
PIVOT [Enrolled Qry].Tenofovir;

TRANSFORM Count([Enrolled M Qry].[Study ID]) AS [CountOfStudy ID]
SELECT [Enrolled M Qry].[Creatinine Group], Count([Enrolled M
Qry].[Creatinine Group]) AS [CountOfCreatinine Group]
FROM [Enrolled M Qry]
GROUP BY [Enrolled M Qry].[Creatinine Group]
PIVOT [Enrolled M Qry].Tenofovir;

TRANSFORM Count([Enrolled F Qry].Tenofovir) AS CountOfTenofovir
SELECT [Enrolled F Qry].[Creatinine Group], Count([Enrolled F
Qry].[Creatinine Group]) AS [CountOfCreatinine Group]
FROM [Enrolled F Qry]
GROUP BY [Enrolled F Qry].[Creatinine Group]
PIVOT [Enrolled F Qry].Tenofovir;
 
Since the source queries aren't the same, I think your simplest solution is
to combine the crosstabs in a final select query.
 
Thanks Duane,

How do I do the final select query?

Duane Hookom said:
Since the source queries aren't the same, I think your simplest solution is
to combine the crosstabs in a final select query.
--
Duane Hookom
Microsoft Access MVP


AGOKP4 said:
Hi,

I'm trying to combine 3 crosstab queries, the SQL statements are below and
get a report out of it. Is it possible to do it this way or try something
else?

Thanks

TRANSFORM Count([Enrolled Qry].[Study ID]) AS [CountOfStudy ID]
SELECT [Enrolled Qry].[Creatinine Group], Count([Enrolled Qry].[Creatinine
Group]) AS [CountOfCreatinine Group]
FROM [Enrolled Qry]
GROUP BY [Enrolled Qry].[Creatinine Group]
PIVOT [Enrolled Qry].Tenofovir;

TRANSFORM Count([Enrolled M Qry].[Study ID]) AS [CountOfStudy ID]
SELECT [Enrolled M Qry].[Creatinine Group], Count([Enrolled M
Qry].[Creatinine Group]) AS [CountOfCreatinine Group]
FROM [Enrolled M Qry]
GROUP BY [Enrolled M Qry].[Creatinine Group]
PIVOT [Enrolled M Qry].Tenofovir;

TRANSFORM Count([Enrolled F Qry].Tenofovir) AS CountOfTenofovir
SELECT [Enrolled F Qry].[Creatinine Group], Count([Enrolled F
Qry].[Creatinine Group]) AS [CountOfCreatinine Group]
FROM [Enrolled F Qry]
GROUP BY [Enrolled F Qry].[Creatinine Group]
PIVOT [Enrolled F Qry].Tenofovir;
Click to expand...
Click to expand...
 
Back
Top