Join tables in Access

[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.

 

[scubadiver]

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?

 

[Klatuu]

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.