'Sort Ascending' loses data

[jonohara]

Hi

I've a table with around 4000 records in a rather large application. The users report missing data, so i've been checking the tables in the backend mdb file on a server.

When i open the table it shows all the records, when I sort the records by surname (not linked to other tables) it shows all the records, however, when i sort by a field which is linked to one other table (many to one , records have a reference in the linked table as well) the dataset shrinks to a few hundred.

Thus doesn't happen when I import the table into a new database.

Any ideas?

Thanks

 

[BNPMike]

Most likely this is caused by nulls. Change the join to left/right rather than inner.

 

[Blorf]

Also, make sure you have grouping turned off in your query. This has killed me once or twice.

ChaZ

Ascii dumb question, get a dumb Ansi