How to assign a data range for a particular value.

[splashy]

Hi there!


I am trying to create a database for calculating costs of shipping an item depending on the postcode. Here is a picture that explains what I am trying to create: http://i.imgur.com/VrnBkTE.png


So as you can see, in region N1, the cost is $9.90 and covers the postcodes between 1000-2000, 2030, 2050-2070. I want to assign these values to the region N1 with the cost $9.90 so that when I look it up on the query, it shows the correct price. For example, if I were to enter 3502, I would expect it to show that it is in region N2 with a cost of $15.30.


I cannot figure out how to enter a data range to make this easy. Any help would be greatly appreciated!

[June7]

The table needs two fields for the range - [begin] and [end].

Then a record for each range for each region.

SELECT * FROM Prices WHERE [enter post code] BETWEEN [begin] AND [end];