link tables using query

[Guest]

I have two tables. The first table is a list of items including a text entry
drawn from the second table via a combo box . The second table is a summary
of the different budget accounts from which monies are draw to cover the
individual items in the first table.

When I run a query to base my report on, the query returns a numeric value
instead of the text from the second table. How do I get it to return the
text value?

Thanks

 

[Arvin Meyer [MVP]]

Add the second table to the query and Join on the numeric value. Display the
field with the text data in that query in place of the numeric value.