I'm writing a simple Access 97 database to track service hours by parents at my daughters elementary school. When service hour work is performed, the operator chooses from a look-up list based upon another table. Problem is, when I do a query to list the various jobs performed, the program returns a list numbers from the other table's Autonumber column, instead of the actual text (EventWorked). The field is identified as Text, both in the query setup and in the look-up table's definition. How do I reason with Access 97 to return the text and not the entry number? Please accept my apologies in advance for the rudimentary nature of my question, but one has to start somewhere, right?

Create a query which joins both tables and select EventWorked from the look up table.
HTH