Append two queries?

[kestefon]

Is it possible to append two queries? The queries have the same layout and labels...it's just a matter of combining the data into one datasheet view.

The two queries are below:

1)

SELECT prc.Market AS Geography, trp.Product, trp.Indication, trp.[Variable Name], trp.Period, Round(prc.Index*trp.[Variable Value],2) AS [Variable Value], trp.Outlet, trp.Daypart, trp.[Program Name], trp.Len, trp.Creative, trp.Campaign, trp.[Campaign Name], trp.[Media Type], trp.Vendor, trp.Channel
FROM tblTRP AS trp, tblTRPpercent AS prc
WHERE (((trp.Indication)=prc.Indication) And ((trp.[Media Type])=prc.Type) And ((trp.Geography)="National") And ((trp.Month)=prc.Month));


2)


SELECT prct.DMA AS Geography, tv.Product, tv.Indication, tv.[Variable Name], tv.Period, Round(prct.percentUniverse*tv.[Variable Value],6) AS [Variable Value], tv.Outlet, tv.Daypart, tv.[Program Name], tv.Len, tv.Creative, tv.Campaign, tv.[Campaign Name], tv.[Media Type], tv.Vendor, tv.Channel
FROM tblTVOtherMetrics AS tv, tblDMApercent AS prct


WHERE (((tv.Geography)="National"));

[lfpm062010]

Not sure what you mean "Append Two Queries?"

To combined two queries as one, you can use "UNION" (or UNION ALL)
http://msdn.microsoft.com/en-us/libr.../ff821131.aspx (for the UNION/UNION ALL differences)

[kestefon]

Well, I basically want to rewrite my existing queries (which are separate), so that the result is one big query as opposed to two. The two queries have the same field labels and the same type of data, so I want to consolidate them.

[lfpm062010]

You are selecting from 4 different tables (2 tables on each query). It will not be easy to cosolidate them.

Create another query and use UNION or UNION ALL on those 2 query should work.