link tables using query

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
Back
Top