Return a blank feild

G

Guest

I have two tables. Both of them have two feilds DEVICE and QTY. They are
linked together in the query by the device feild. The same devices are not
always in both tables. I would like to be able to have all of the devices
shown when the query is run and the devices don't match to just have a zoer
in the qty feild instead of Access 2000 omitting the device. Any
suggestions?? Thanks
 
J

Jeff Boyce

Open the query in design view.

Click on the line joining the two tables. Right-click on it to get the
properties.

Change the type of join from "equi" (where the same value is in both tables)
to "directional" (you get all from table1 and any matching values from
table2).

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

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

Append query wont run because: 8
Adding an extra feild to a query 6
How can I use a text string as a query parameter? 2
Building a query 3
I need a way to format a numerical feild to display 2 decimal 3
Problem with a query comparing multiple feilds 1
Adding values in two feilds based on condition 1
Simple query help 1

Top