I'm trying to create a form as follows: The information is being imported to a table from an Excel spreadsheet. Several of the Excel fields are number values that were entered using a code chart (e.g., 1=buildings, 2=homes, 3=agriculture etc.). There was no lookup value list used, just a handwritten list.

I want the form to display the actual meanings like "buildings" or "homes" and not the numbers. How can I do this?

Thanks.

Create a two field table. Put the number in one and the text equivalent in the other. Add this table to the query along with the table that has the numbers. Create a join between the two number fields. Place the text equivalent field in the QBE grid.