I have 2 queries that provide the following information:

Query 1
Vendor ID
Ship Qty

Query 2
Vendor ID
RejectQty

Is there a way to run these 2 queries and make 1 table with the following
information?

Vendor ID Ship Qty Reject Qty


Thanks,
Jasper

Sure. Create a 3rd query that joins them together (as though they were
tables), and use that query.

The SQL would look something like:

SELECT Query1.VendorID, Query1.ShipQty, Query2.RejectQty
FROM Query1 INNER JOIN Query2
ON Query1.VendorID = Query2.VendorID

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Jaz" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I have 2 queries that provide the following information:
>
> Query 1
> Vendor ID
> Ship Qty
>
> Query 2
> Vendor ID
> RejectQty
>
> Is there a way to run these 2 queries and make 1 table with the following
> information?
>
> Vendor ID Ship Qty Reject Qty
>
>
> Thanks,
> Jasper
>
>

Perfect!

One more question: If this 3rd query uses the other queries to run, does it
actually run the 2 queries first?

So if I make a change on any of the first 2 queries, will it affect the 3rd
query?

Thanks,
Jasper



"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
news:(E-Mail Removed)...
> Sure. Create a 3rd query that joins them together (as though they were
> tables), and use that query.
>
> The SQL would look something like:
>
> SELECT Query1.VendorID, Query1.ShipQty, Query2.RejectQty
> FROM Query1 INNER JOIN Query2
> ON Query1.VendorID = Query2.VendorID
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "Jaz" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> >I have 2 queries that provide the following information:
> >
> > Query 1
> > Vendor ID
> > Ship Qty
> >
> > Query 2
> > Vendor ID
> > RejectQty
> >
> > Is there a way to run these 2 queries and make 1 table with the
following
> > information?
> >
> > Vendor ID Ship Qty Reject Qty
> >
> >
> > Thanks,
> > Jasper
> >
> >
>
>

Yes, if you make changes to either of the first 2 queries, those changes
will apply to the 3rd query as well.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Jaz" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Perfect!
>
> One more question: If this 3rd query uses the other queries to run, does
> it
> actually run the 2 queries first?
>
> So if I make a change on any of the first 2 queries, will it affect the
> 3rd
> query?
>
> Thanks,
> Jasper
>
>
>
> "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
> news:(E-Mail Removed)...
>> Sure. Create a 3rd query that joins them together (as though they were
>> tables), and use that query.
>>
>> The SQL would look something like:
>>
>> SELECT Query1.VendorID, Query1.ShipQty, Query2.RejectQty
>> FROM Query1 INNER JOIN Query2
>> ON Query1.VendorID = Query2.VendorID
>>
>> --
>> Doug Steele, Microsoft Access MVP
>> http://I.Am/DougSteele
>> (no private e-mails, please)
>>
>>
>> "Jaz" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>> >I have 2 queries that provide the following information:
>> >
>> > Query 1
>> > Vendor ID
>> > Ship Qty
>> >
>> > Query 2
>> > Vendor ID
>> > RejectQty
>> >
>> > Is there a way to run these 2 queries and make 1 table with the
> following
>> > information?
>> >
>> > Vendor ID Ship Qty Reject Qty
>> >
>> >
>> > Thanks,
>> > Jasper
>> >
>> >
>>
>>
>
>