Join tables in Access


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

Advertisements

S

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?
 
Ad

Advertisements

K

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

joining tables 1
joining tables 6
join 3 tables 0
Joining Tables/Queries 1
Join table and subforms 0
Problem joining two tables 1
Join two tables with an expression? 1
Joining Tables Vlookup equivalent? 1

Top