Join tables in Access

  • Thread starter Thread starter jayesh
  • Start date Start date
J

jayesh

I want to join two tables .
One is receivables and the other is payable.
Payable table fields are : Name , Date , Amount
Receivable table fields are : Name , Date , Amount
Now what I need is when a query is fired For a common name in both the
fields I should get the Data from both the tables for the same name.
 
Can you be sure the information in both table relates to the same person.
What I mean is, does "name" contain the full name?

Does "John" in the payables relate to the same "John" in the receivables?
 
Seems an unusual thing to do, tying payables and receivables, but the short
answer is to join the tables in a query using the Name field.
 
Back
Top