Query to return information from table.

S

SailorRoy

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.
 
J

jltbdy

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.
 
S

SailorRoy

I know that this is probable simple but I don’t know how to do that. Can you
explain? Thank you.
 
Top