Help with querie and sql

[lynn]

I have a form based on a query. For some reason not all
the records show when the query is run therefore do not
display on the form. The record does however exist in the
employeedetails table. Can anyone explain why this might
be happening. the querie SQL is as follows

SELECT employeedetails.*, [post details].*,
selection.action
FROM (employeedetails LEFT JOIN [post details] ON
employeedetails.[post ID] = [post details].[post ID]) LEFT
JOIN selection ON employeedetails.[employee ID new] =
selection.[employee ID];

I cannot see any difference between the records which show
and the records which dont. eg no records have been linked
to a post as yet, nor does either have a link to the
selection table. In fact, I imported 20 records all with
just names and addresses to the employeedetils table, but
only some of these show in the query - I cannot see the
difference. I need all employee details to show whether
they have a current post or selection record.

What have I done wrong?
..

 

[[MVP] S.Clark]

See my response in your post from yesterday.