Query problem

  • Thread starter Thread starter jimmy
  • Start date Start date
J

jimmy

Hi,

I have two tables (A & B), all fields is same but when i made a query to
listing out all records from A and B. I have already made the relationship
between A and B as invoice number. There is nothing to show on the query.

Please help
Jimmy
 
Hi Jimmy,

Let me guess, English isn't your first language? You may not get much help
with this, it is a little difficult to understand.

Maybe you could post your SQL so we can see it?

Jamie
 
Dear Jimmy:

Are all your invoices present in both tables? Are some of your
invoices present in both tables? It sounds like none of the invoices
are present in both tables.

It is very difficult to see what you are doing, or why? It is almost
always best to have only one table in a situation like this. Why two?

I think you would likely be better served with a UNION query here.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
Back
Top