display all records

[Lynn atkinson]

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]

With both of the left joins, ALL of the employeedetails data should be
displayed. You may need to examine those records to see if there is
anything odd about them. Another thing to try is to take away one of the
joins, and see if the records show. Test with each join, and determine the
cause.

 

[lynn]

Thanks for the reply. I was being a bit dim - the records
were not sorting by ID number, so a batch of the new
records added were not in numberical order and therefore
were making me think they were not displaying!

thanks for your help anyway.

-----Original Message-----
With both of the left joins, ALL of the employeedetails data should be
displayed. You may need to examine those records to see if there is
anything odd about them. Another thing to try is to take away one of the
joins, and see if the records show. Test with each join, and determine the
cause.


--
Steve Clark, Access MVP
FMS, Inc.
www.fmsinc.com/consulting

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?

.