No Data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

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

How to Populate Data from a table to another 0
Linked Query not Updateable 2
VBA - retrieve data on last create named range from previous inserted named range 0
How to export table from outlook into ms access table? 0
Query with common fields to all records 6
How I can make linked query? 1
Checking if data exists another table and, if yes, extracting a value 0
Move Data into a blank field in a query 10

Back
Top