Combine feilds of two queries (1 Viewer)

[jamil_786]

Dear freinds I have two queries “PO Aging” & “SC Aging” based on different tables and the queries show with below results.

PO Aging
Vendor PO# Invoice Age days
ABC 23 456 12
DEF 899 222 10

SC Aging
Vendor SC# Inv# Age days
AFG 963 222 5
XYZ 852 111 12

I want to combine fields of both queries in another query with following criteria.

Vendor PO#/SC# Invoice Aging
ABC 123 456 12
DEF 899 222 10
AFG 963 222 5
XYZ 852 111 12

 

[ColinEssex]

In your final query, where does the ABC 123 come from? It doesn't appear in any of the other two.

Col

 

[jamil_786]

Sorry there was typing mistake. The correct is Invoice# ABC 123. There is wrong Invoice# mentioned in PO Aging.

 

[Rabbie]

lLook up UNION Queries in Access Help. this should do exactly what you want