Re: using dlookup as control source

Tech-Archive recommends: Fix windows errors by optimizing your registry

Douglas,

I think i did not explain how the discount is calculated. basically, i have
a table called HIre discount, which looks like this:

>From To Discount (%)
0 6 5
7 10 8

where from and to are number of days.

i tried to use the syntax below which i adapted from your previous post but
it does not work:

=DLookUp("[DISCOUNT (%)]","[HIRE DISCOUNT]","[NUMBEROFDAYS] BETWEEN" &
"FROM" & "AND" & "TO")

where have i gone wrong?

thanks

shaheed

.