Still showing numbers not text in display

[LilP]

Since my previous post I went through both tables and did the lookup
wizard on all the fields and selected only the RATING not ID. When I pull
both tables into my query it shows the number for some and the word for
others. The frustrating part is they were all created the exact same way so
why are they displaying differently? I checked all the properties on both
tables and everything is exactly the same and the information is still
displaying in 2 different formats. Help before I pull all my hair out... =(
Thanks for the quick responses by the way!

 

[LilP]

Also... When I pull each table by itself into the query it shows the text not
the id but when I add the tables together is when it switches to id???? I
think Access doesn't like me....

 

[John W. Vinson]

I went through both tables and did the lookup
wizard on all the fields and selected only the RATING not ID.

The Lookup Wizard *WILL NOT HELP YOU HERE*.

Don't use it, *at all, ever* would be my suggestion.

Instead, create a new Query. Add the Performance Review table and the Ratings
table. Join them by the numeric ratingID field (if Access doesn't do so for
you automatically). Save this Query and base your report on it.

John W. Vinson [MVP]