Microsoft Access Querries

[Jackie]

Hi,

I have a database created in ms access. Why is that when I
created a multiple queries it seems to default to
something.

For example: I have 3 tables with the same setup except
with different data in it. For table 1 it will have
multiple result, table 2 will also have multiple result
and table 3 only have one result.

So when I do the querries, it doesn't seems to find the
rest of the result it will only display the one particular
result which is the result found in table 3.

I don't quite understand this. Can someone

 

[Jeff Boyce]

Jackie

Please post your SQL.

By the way, your description sounds like you have 3 identical tables -- if
so, why? This would not be a well-normalized design, and could lead to
problems when you try to query them ... hmmm?

Jeff Boyce
<Access MVP>