[AccessD] Union the transform queris ?

hey group.

Is it possible to perform an union query on 2 (or more) transform queries
if the field names are he same ?

TRANSFORM Count([Ron Data spr].[ID]) AS Total
SELECT "Closed without Investigation" AS Status
FROM [Ron Data spr]
WHERE ([Ron Data spr].[Preliminary Investigation Closed] >=
[Forms]![Report Form]![Start_Date]) And ([Ron Data spr].[Preliminary
Investigation Closed]<=[Forms]![Report Form]![End_Date]) and ([Preliminary
Investigation closed] is not null and [Investigation Opened] is null)
GROUP BY  "Closed without Investigation"
PIVOT Format([Preliminary Investigation Closed],"mmm") In
("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec")

TRANSFORM Count([Ron Data spr].[ID]) AS Total
Union SELECT "Pre Investigation Opened" AS Status
FROM [Ron Data spr]
WHERE ([Ron Data spr].[Preliminary Investigation Opened] >=
[Forms]![Report Form]![Start_Date]) And ([Ron Data spr].[Preliminary
Investigation Opened]<=[Forms]![Report Form]![End_Date]) and [Preliminary
Investigation Opened] is not null
GROUP BY "Pre Investigation Opened"
PIVOT Format([Preliminary Investigation Opened],"mmm") In
("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec");



-----------------------------------------
Get Breaking News from CNN, ABC, NBC, CBS Now.
http://www.xuppa.com/news/?link=webmail