would anyone know of a reason why a query in access 2000 that does not filter out any records would not find data in the appropriate tables? if i enter data directly into the tables, everything works. if i import data, it is hit or miss.
Printable View
would anyone know of a reason why a query in access 2000 that does not filter out any records would not find data in the appropriate tables? if i enter data directly into the tables, everything works. if i import data, it is hit or miss.
Are you joining two tables?
It could be a lot of things. . .
could be that your keys don't match (potentially due to whitespace)
thank you johnatwork. you used the keywork "whitespace" in your reply and then i remembered that the original datasource was a fixed-width text file. i just used the "trim" function to remove all of the extra spaces and everything is back to working perfectly.
thank you.