Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how to get values in a table?

Status
Not open for further replies.

claubrin

Technical User
Oct 22, 2000
1
BR
Sorry I´m a beginner.
I have a table with 20 regions and 3 products with their respective prices. The price changes in function of region and kind of product. I want to know to select the correct price from region and product.
thanks [sig][/sig]
 
Create a query
Then Enter this in the column you want to specify
Mkae usre you put in the [] Brackets before and after your text.
put [Enter Region] in the region column in the Criteria row
[Enter products] in the products column in it's Criteria row

then run your query by clicking the RED exclamtion mark
It should prompt for a region
Make sure you key in a valid region
Then it should pormpt for a Product
Then you should see products that match your region and product.
;-)

DougP, MCP
dposton@universal1.com

Ask me how Bar-codes can help you be more productive.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top