Records being removed from query

[steallan]

Hi

i have a query that shows 190000 records made up from related fields spread over many tables.

now i add in a new field to the query. It is related in the same way the others are, and indeed the information now appears in the query matched up correctly.

But for some reason the query now shows 670 less records?????

why is Access removing some records because of this new field??

can anyone help?

thanks

Stephen

 

[Bat17]

because there is not matching data in the joining fields. Access normaly just shows the records where the data is present on both sides. If you right click on the join you can change this behaviour but I would check your data integrity first!

Peter