queries in access 2000

[dwhawley]

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.

[JohnAtWork]

Are you joining two tables?

It could be a lot of things. . .
could be that your keys don't match (potentially due to whitespace)

[dwhawley]

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.