I am having trouble with the below returning the correct number
of records, and can't see why.
I have one table, tblDevice, which
has 4 columns, ID | DeviceRecNo | ExcludeFromCheck |
ID - Autonumber
DeviceRecNo - Number
ExcludeFromCheck - Number (1 = yes, 0 - No)
I have the following running as part of some code, but it
is not returning the correct number of records, and I cant see why
not. I have tried creating this in a query in Access itself, and copy
the SQL into VBA and it still doesn't return the correct number
records, any help would be appreciated.