Query based on banding parameters

[Db396]

Hi

I have a fact table which contains a list of products at many different Retail Prices. I want to band these products into groups based on Retail Price Bands.

I have created a second table with the fields Retail Price Band, Minimum Retail Price, Maximum Retail Price. This defines the banding structure.

I would like to join Retail Price with Retail Price Band based on the parameters in the second table but don't know where to begin.

Would be grateful for any suggestions on how to approach this.

Thanks
David

 

[JHB]

Try, (remember to change the table name and field to what you use).

SELECT BandTable.[Band], ProduktTable.Produkt
FROM BandTable, ProduktTable WHERE [Retail Price] Between [Minimum Retail Price] And [Maximum Retail Price];

 

[Db396]

Works perfectly.

Many thanks for your help
David

 

[JHB]

You're welcome, luck with your projekt.