Query Question

[lloyd2002]

I have a query that pulls data from three tables, and are linked by a stock number data value in a field in each of the three tables.

I'm trying to add date field into the query from one of the tables, in which some of the records have no data. When I do this and link with the stock number value, I only see the number of total stock items that have an entry in this date field. If I remove the link I see all the stock items, but they now all have dates from this date field when some of them should be blank.

Any ideas on how I can show all of the stock items and the required date from this table?

 

[Joe4]

The default join type between tables is the INNER JOIN. In an INNER JOIN, records are only returned if they exist in ALL tables.
If you want to return all records, even if some do not have matches in other tables, you need to do a LEFT JOIN from the table that contains all the records.

See here for a tutorial on how to set up LEFT JOINS in the Access Query Builder: MS Access 2003: Create a query using a Left Join

 

[lloyd2002]

Cheers Joe