I want to use [LevelOfService] which can be any number, find where it lies within the range of [MinMbps] and [MaxMbps], and derive the [BookPrice]
I am using two tables [tblOrders] and [tblPriceBook].
[tblOrders] has the field [LevelOfService]
[tblBookRate] has the fields [MinMbps], [MaxMbps], and [BookPrice].
I have attempted to use the following:
I am attempting this in a query.Code:dlookup("[BookRate]","[tblPriceBook]", "[tblPriceBook].[MinMbps]< & [tblOrders].[LevelOfService] & AND [tblPriceBook].[MaxMbps]>")
Any input is appreciated. I’m quite new at this and don’t have much experience in the realm of Access.