Store Query Results in a Temporary Table

[theDBguy]

Hi. You'll need to adjust your UNION query result to come up like this, if you want to be able to produce a CROSSTAB query like that.

Dept1  11
Dept2  8
Dept3  3
and so on...

 

[JithuAccess]

Hi. You'll need to adjust your UNION query result to come up like this, if you want to be able to produce a CROSSTAB query like that.

Dept1  11
Dept2  8
Dept3  3
and so on...

Thanks a lot. Do you have any idea how to do this?
This is my Query:

Select [Total Corrsepondence] from [QryDepartment1] Union all
Select [Total Corrsepondence] from [QryDepartment2] Union all
Select [Total Corrsepondence] from [QryDepartment3] Union all
Select [Total Corrsepondence] from [QryDepartment4] Union all
Select [Total Corrsepondence] from [QryDepartment5] Union all
Select [Total Corrsepondence] from [QryDepartment6] Union all
Select [Total Corrsepondence] from [QryDepartment7] Union all
Select [Total Corrsepondence] from [QryDepartment8]

Here [Total Correspondence] is Field Name and [QryDepartment1] is Query Name

Thanks

 

[theDBguy]

Thanks a lot. Do you have any idea how to do this?
This is my Query:

Select [Total Corrsepondence] from [QryDepartment1] Union all
Select [Total Corrsepondence] from [QryDepartment2] Union all
Select [Total Corrsepondence] from [QryDepartment3] Union all
Select [Total Corrsepondence] from [QryDepartment4] Union all
Select [Total Corrsepondence] from [QryDepartment5] Union all
Select [Total Corrsepondence] from [QryDepartment6] Union all
Select [Total Corrsepondence] from [QryDepartment7] Union all
Select [Total Corrsepondence] from [QryDepartment8]

Here [Total Correspondence] is Field Name and [QryDepartment1] is Query Name

Thanks

Yes, try it this way...

SELECT "Dept1" As Dept, [Total Correspondence] FROM qryDepartment1
UNION
SELECT "Dept2", [Total Correspondence] FROM qryDepartment2
UNION
SELECT "Dept3", ... and so on.