ACCESS

[Guest]

I created a very simple query that consists of two tables. Even though there
are matches in the two tables, the query does not retrieve them. The tables
were imported from Excel spreadsheets and both fields I'm trying to match are
text, even though they contain all numberic data. This seems so simple, but I
cannot get it to pull the data. I even reduced the tables down to seven
records in Table 1, and only one record in Table 2 (the record contains data
that matchs the joined field in Table 1. Does anyone have any suggestions?
I'm pulling my hair out on this one!

 

[Guest]

Without knowing any more, I would suggest you check the data types of both
fields that you are linking and make sure they match. If they are both text,
make sure there are no extra characters at the end of the text (extra
spaces). Also check the join properties in the query to make sure you get
the results you want.

 

[Guest]

Thanks for your response. I had already check everything you suggested. Found
out later that one of the files was corrupted! Thanks, anyway.

Jan