Re: Joining two queries...Please Help

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Carlee:

See my response to your previous post. If you have created two queries, one
for July with no match in August, and one for August with no match in July,
you can then UNION the two queries together to put them in one query. This
assumes each query has the same fields. For example:

QueryJulyWithNoAugustMatch.Field1, ...
UNION
QueryAugustWithNoJulyMatch.Field1, ...


--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


"Carlee" <Carlee@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A51DF640-D0D9-41C7-AF1F-E449F023F444@xxxxxxxxxxxxxxxx
Hi there,
I have two queries that give me the information that i need. I want to join
these queries together to have the results show in one query, not two. I
need this because i have to use the results for invoicing purposes.
'Offer',
a fellow newgroup user, kindly provided this sql statement, but I am unsure
how to incorporate it into my scinario, using to queries.

Essentially, I have one table, tblPrintActuals. In one query I have all
print counts for the month of July, including the serial number for each
device. In the second query i have all print counts for the month of
august,
including serial number for each device.

When I create a third query, using the 'find unmatched' wizard, I can get
those records that have an impression for july but not august. To get the
reverse, (those devices that have impressions for august that are not in
july.)

Issue, how can i get the results of both of these queries in one.

Many kind regards,
--
Carlee


.

Relevant Pages

  • Re: Submitting is easy once you stop thinking about it
    ... > letter to send out another query. ... > it is now common practice for authors to send out multiple queries. ... > always happy to offer a quick professional peek and response (a.k.a. ... Same question with an agent. ...
    (rec.arts.sf.composition)
  • RE: Dynamically referencing a recordset?
    ... through that recordset to set the query parameters in VBA. ... to be the one who had to modify 1440 queries if there is a change in the ... different table schema, then you need 3, one for each record type. ... This is a database that tracks the production on records in another ...
    (microsoft.public.access.modulesdaovba)
  • Re: Was: what does "serialization" mean?
    ... > the specific queries up front. ... that the NEXT time the query is run the query is fast, ... data base, don't know squat" when in fact the Donald clone doesn't ... >> WHATEVER would probably be a separate query to summarize total sales. ...
    (comp.programming)
  • Re: Official Status of SQLServer 2005 ADP
    ... I have said that the support for SQL passthrough ... queries under MDB was bad and worst than the one offered by ADP while you ... > attempt to "pass through" every Access query against a linked ODBC ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Cluster synchronize
    ... queries per unit time. ... CPU is the ONLY bottleneck. ... increase in query capacity. ... queries that perform sequential I/O or queries performing random I/O. ...
    (microsoft.public.sqlserver.clustering)