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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Populate Data from a table to another 0
Run 2nd query using results from 1st query 0
Report Query Works 2nd Time, But Not 1st 14
Query Returning too many records 4
Update of Existing Table Numeric Value Using DCount from Another T 3
Duplicate Query assistance 2
Union and group, then count 1
text conversion to number on select query 5

Back
Top