IIF A=x then B=A+1

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

....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
 
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])
 
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...
 
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...
 
Back
Top