how can i show blank cells in a query?

  • Thread starter Thread starter Phuong
  • Start date Start date
P

Phuong

I made a query with 3 table. I need to show blank cells to show all records.
How do i also include the blank cells? Please Help!
 
Open your query in design view.
Right Click on the line that joins the tables.
You should get a Join Type dialog. If you get a menu instead, close it and
try again. You have to have the mouse pointer just right.

The radio button #1 is probably selected "Show only records that match"
Select either #2 or #3 depending on which table is the One side of the
relationship.
Do this for all the joins.
 

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

Excel Concatenate with line breaks but ignore blank cells 3
I want to make One Cell mandatory if another cell has a specific value , can anyone help me? 0
How does one eliminate blank records on a query result? 3
Excel Add ^ to a row of cells containing letters 3
Convert zero-length string or blank cell to null 3
Excel Sumproduct 0
Excel formula, sum the value cell and if empty cell left blank 0
How to do a lookup to show whether there is a match another table 2

Back
Top