Table Relatiotionships and data exchange

[Steve]

I have 2 tables that have data obtained from a mainframe application on a daily basis. One is Loans Approved and the other table is Loans Funded. The Loan number would be the common element in both tables

I need to be able to show only those loans from the loans approved table that are not in the loans funded table

How can I accomlish this by a query or what?

Any help would be appreciated.

 

[Allen Browne]

Yes. There is an Unmatched Query wizard to achieve this for you.

Essentially, it gives you an outer join where [Loans Funded].[LoanID] is
null.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I have 2 tables that have data obtained from a mainframe application on a

daily basis. One is Loans Approved and the other table is Loans Funded. The
Loan number would be the common element in both tables.

I need to be able to show only those loans from the loans approved table

that are not in the loans funded table.

 

[Steve]

Thanks Allen