A
Ange Kappas
Hi All,
I worked it out by myself after trail and error using
DLookup in a independent control (named it getrate) and then using the
setvalue as a macro copied the getrate value into the DAILY CHARGE control.
This is the DLookup as I woked it out
=DLookUp("[PRICE]";"PRICELIST";"[COMPANY]=[RESPEL]![COMPANY]AND[RESPEL]![TYPECHARGE]=[CHARGE]AND[RESPEL]![PRICELIST]=[CATEGORY]AND[RESPEL]![ARRIVAL]>=[START]AND[RESPEL]![ARRIVAL]<=[END]")
Hope it helps someone else
Bye
Ange
I worked it out by myself after trail and error using
DLookup in a independent control (named it getrate) and then using the
setvalue as a macro copied the getrate value into the DAILY CHARGE control.
This is the DLookup as I woked it out
=DLookUp("[PRICE]";"PRICELIST";"[COMPANY]=[RESPEL]![COMPANY]AND[RESPEL]![TYPECHARGE]=[CHARGE]AND[RESPEL]![PRICELIST]=[CATEGORY]AND[RESPEL]![ARRIVAL]>=[START]AND[RESPEL]![ARRIVAL]<=[END]")
Hope it helps someone else
Bye
Ange