I am converting a Paradox 8 based application to Access 2007. It appears that often Paradox queries drop out records and Access includes them. To the best of my ability the test data is the same and the queries are the same. I am looking at Paradox quereis written in the PAL script .vs. Access graphical queries. I've tried Access/SQL Select Dinstinct and no help. Anyone got any ideas? Thanks.