A
Ana_T
Hi,
I have a report which has these parameters:
Vehicle A.
Km at sale date: 151.000
Km at actual date: 157.000
Dif_km: 6.000
Vehicle B.
Km at sale date: 78.000
Km at actual date: 94.000
Dif_km: 16.000
Fields from a query:
KM_sale
KM_actual
Dif_KM
I need to create an IF statement which would alert for the two following
conditions:
1. If at sale date the vehicle had less then 150.000 km then check the
difference between km and if it is less then 10.000 do nothing otherwise
show 'ALERT1'.
2. Is at sale date the vehicle has more then 150.000 km then check the
difference between km and if it is less then 5.000 do nothing otherwise
show 'ALERT2'
I tried the following expression with no avail.
=IIf([km_sale]<150000;IIf([dif_km]<10000;"";'ALERT1');IIf([dif_km]<5000;"";'ALERT2'))
Any help is appreciated.
TIA
Ana
I have a report which has these parameters:
Vehicle A.
Km at sale date: 151.000
Km at actual date: 157.000
Dif_km: 6.000
Vehicle B.
Km at sale date: 78.000
Km at actual date: 94.000
Dif_km: 16.000
Fields from a query:
KM_sale
KM_actual
Dif_KM
I need to create an IF statement which would alert for the two following
conditions:
1. If at sale date the vehicle had less then 150.000 km then check the
difference between km and if it is less then 10.000 do nothing otherwise
show 'ALERT1'.
2. Is at sale date the vehicle has more then 150.000 km then check the
difference between km and if it is less then 5.000 do nothing otherwise
show 'ALERT2'
I tried the following expression with no avail.
=IIf([km_sale]<150000;IIf([dif_km]<10000;"";'ALERT1');IIf([dif_km]<5000;"";'ALERT2'))
Any help is appreciated.
TIA
Ana