how to get values in a table??

[Guest_imported]

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 how to select the correct price from region and product.
thanks

 

[Bachenot]

The fields in your table appear to be the following:
regions
product1
price1
product2
price2
product3
price3

Let us assume that your table name is Goods. Then you can build SQL in the query window that might look something like this:

Select price1 from Goods
where price = 25;

Is this what you are looking for? [sig][/sig]