Oke, this is a though one.

In my truck registration database I have a field called GVW (gross Vehicle Weight). This value is between 2800 kg and 90000 kg

I want to make three groups, Light, Medium and Heavy. The specification of the groups I put into a table.

tblGVW
GvwId
WeightMin
WeightMax
TxtDescription

example

GvwId: 1
WeightMin: 2800
WeightMax: 6000
TxtDescription: Light

Now I want to have a query where for example a truck with a GVW of 4500 kg the text Light appears.


Thanks

Please don't post the same question in multiple places. I gave you an answer in another thread.