Was investigating an issue where a query based on form parameters were not returning all relevant records and found it went one level worse and even a new select query with no criteria just passing the table through doesn't even return all the records.
I'm confident its a rookie error as in the...