On Tue, 24 Jan 2006 09:30:05 -0800, "JohnB" <JohnB@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>Any ideas on this please? I can supply SQL for the two seperate queries I've
>produced, if it will help. The way I envisage this is that I want to be able
>to take the first queries list of records and stack them on top of the second
>queries list.
A UNION query does precisely this. See the online help for UNION, and
post back if it's not clear how to use it in your case.
Re: Reporting from Queries ...survey, check the At Your Survey demo at ... I tried the union query but it only works ... > different tables or queries.... I want the report to run for only the ... (microsoft.public.access.reports)
Re: HELP~Query Not pulling all the data ... I have created both the queries that returned the data I ... Now the issue of the Union Query.... I want to get Account... Year, Annual Budget & SumofAmount. ... (microsoft.public.access.queries)
RE: Argument Error in Union Query ... I never heard of a union query messing up the queries it is combining. ..."KARL DEWEY" wrote: ... (microsoft.public.access.queries)
Re: Multiple sources for Reports ... a union query like: ... SELECT "Water Quality" as Source, Yearas Yr, Countas NumInsp ... all of the inspections and things we do for our stormwater permit. ... would like to generate queries that totals up the number of inspections ... (microsoft.public.access.reports)
Re: Union query and exclusion of data ... -- Records in A or in B but not in both (Last two queries above) ...Access MVP 2002-2005, 2007-2008 ... I am usin Access 2003 Pro and trying to create a rather complex union query but don't seem to implement conditions. ... I have tried all INNER JOIN, LEFT JOIN and RIGHT JOIN but none of them have worked so far. ... (microsoft.public.access.queries)
