No Data

T

Tracy Lamphier

I have 4 tables linked in one query. Three of the tables are linked by
account number, which if an account is in one table it will be in all three.
However, my last table is not going to have data for eac accounts. When I
link this 4th table it will leave out those accounts that have no data on the
4th table.

I tried the Is Null or "" expressions but they still don't work. How do I
get the data from the other 3 tables to still display even if there is
nothing in the 4th table?
 
D

Douglas J. Steele

You need to use either a Left Join or Right Join (depending on which table
is listed first in the statement)

If you're creating the query through the GUI, select the line joining the
two tables, right-click and select the appropriate option on the Join
Properties window.
 
T

Tracy Lamphier

That worked. Thank you!

Douglas J. Steele said:
You need to use either a Left Join or Right Join (depending on which table
is listed first in the statement)

If you're creating the query through the GUI, select the line joining the
two tables, right-click and select the appropriate option on the Join
Properties window.
Click to expand...
 
Top