Return a blank feild

U

uuhhgg

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
 
Top