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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.