Query to return information from table.

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

Guest

This is my problem and I have struggled with it for a week with no answers:
I am running a query that returns a part number; I then want the query to
bring up a value that is in a table to compare the information. Example:
Query returns PartNumber PT-1234 I want to it to go to PartNumberTable and
return for PartNumber PT-1234 the cost. I am not very good at this so
detailed information would be appreciated.

Thanks for any help.
 
This is my problem and I have struggled with it for a week with no answers:
I am running a query that returns a part number; I then want the query to
bring up a value that is in a table to compare the information. Example:
Query returns PartNumber PT-1234 I want to it to go to PartNumberTable and
return for PartNumber PT-1234 the cost. I am not very good at this so
detailed information would be appreciated.

Thanks for any help.
Click to expand...

Maybe I dont understand, but why dont you link in the second table
into the same query with a join between PartNumber. Then include any
fields(ie cost, model description, etc) desired.
 
I know that this is probable simple but I don’t know how to do that. Can you
explain? Thank you.
 

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

Query to return information from table. 3
Tables and queries 2
Need query to fill in missing data on table 1
Return Bottom Values 12
Query to compare information between tables 3
Move Data from Column to Row 2
query - max ID number 2
query a history table 7

Back
Top