IIF A=x then B=A+1

A

aaearhart

....for the most part.

This is for a travel schedule report for our US and UK travelers.
Essentially, if a US traveler leaves for Italy on 10 October, he doesnt
arrive in Italy until 11 October. However, if a UK traveler leaves for Italy
on 10 October (usually) he arrives in Italy on 10 October.

so i need something like this

IFF([Citizenship]=United States, [ArrivalDate]=[StartDate] +1 else
[ArrivalDate]=[StartDate])

i realise that's very poor 'grammar', so please, bear with me.

thanks!
/amelia
 
O

Ofer

I assume you want to dispaly this value in a field in a report that called
[ArrivalDate], if that the case, then in the control source of the field you
can write

= IIF([Citizenship]="United States", [StartDate] +1 , [StartDate])
 
A

aaearhart

yay! thanks a mill!

Ofer said:
I assume you want to dispaly this value in a field in a report that called
[ArrivalDate], if that the case, then in the control source of the field you
can write

= IIF([Citizenship]="United States", [StartDate] +1 , [StartDate])

--
I hope that helped
Good luck


aaearhart said:
...for the most part.

This is for a travel schedule report for our US and UK travelers.
Essentially, if a US traveler leaves for Italy on 10 October, he doesnt
arrive in Italy until 11 October. However, if a UK traveler leaves for Italy
on 10 October (usually) he arrives in Italy on 10 October.

so i need something like this

IFF([Citizenship]=United States, [ArrivalDate]=[StartDate] +1 else
[ArrivalDate]=[StartDate])

i realise that's very poor 'grammar', so please, bear with me.

thanks!
/amelia
Click to expand...
Click to expand...
 
O

Ofer

Your welcome
--
I hope that helped
Good luck


aaearhart said:
yay! thanks a mill!

Ofer said:
I assume you want to dispaly this value in a field in a report that called
[ArrivalDate], if that the case, then in the control source of the field you
can write

= IIF([Citizenship]="United States", [StartDate] +1 , [StartDate])

--
I hope that helped
Good luck


aaearhart said:
...for the most part.

This is for a travel schedule report for our US and UK travelers.
Essentially, if a US traveler leaves for Italy on 10 October, he doesnt
arrive in Italy until 11 October. However, if a UK traveler leaves for Italy
on 10 October (usually) he arrives in Italy on 10 October.

so i need something like this

IFF([Citizenship]=United States, [ArrivalDate]=[StartDate] +1 else
[ArrivalDate]=[StartDate])

i realise that's very poor 'grammar', so please, bear with me.

thanks!
/amelia
Click to expand...
Click to expand...
Click to expand...
 
Top