Between a Group of Numbers

[sislman]

Hi,

I the following table named 'Claims' which contains some claims information.

[Scheme] [Claimant] [Claimed Amount] [Excess Banding]

X Cars J Smith £150
X Cars J Bloggs £250

Each Scheme has various levels of cover available which are defined in the following table named 'Scheme Matrix'

[Scheme] [Excess Banding]

X Cars £200
X Cars £400
X Cars £600

Based upon the [Claimed Amount] I need to show a Value in the [Excess Banding] column in the 'Claims' Table.

For example: -

J Smith has claimed for £150 therefore the Excess Banding would be £200.
J Bloggs has claimed for £250 therefore the Excess Banding would be £400.

Im not sure how I would go about the writing a query that would do this for me.

Any help would be appreciated.

Thanks

 

[jdraw]

Could you please describe what these mean exactly?

J Smith has claimed for £150 therefore the Excess Banding would be £200.
J Bloggs has claimed for £250 therefore the Excess Banding would be £400.

 

[sislman]

Hi,

The Cover Options on the X Cars Scheme are: -

£200
£400
£600

If J Bloggs has Claimed for £250 then it is most likely he Purchased the £400 Option. He couldn't have purchased the £200 Option as his claim exceeds this limit.

What I am trying to do here is allocate the most likely Excess Banding purchased based upon the value of the Claim.