Dlookup()

[Freshcan]

Hi everyone,

I'm unable to get my DLOOKUP function to work.

I have a Sales field and the following table that charges a Tax based on the Sale amount.

tblTaxRate

Rate	From	To
0	0	100
5	101	200
10	201	300
15	301	400

In my query I have setup a DLOOKUP to work out the Tax rate based on the Sales Field. i.e. If it is between $101 and $200, a tax rate of 5% will be charged.

Here is my DLOOKUP:
Expr1: DLookUp("[Rate]","tblTaxRates","[Sales]=">"[From] & <[To]")

Can someone identify what's wrong?



Thank you

[R_Badger]

I'd try something more like:

Dlookup("[Rate]","[tblTaxRates]","" & [Sales] &">[From] and " & [Sales] & "<[To]")

But be warned my brain is only firing on one cylinder this afternoon!

[Freshcan]

I'd try something more like:

Dlookup("[Rate]","[tblTaxRates]","" & [Sales] &">[From] and " & [Sales] & "<[To]")

But be warned my brain is only firing on one cylinder this afternoon!

Thank you very much! Works great! Can't thank you enough.