|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 10th, 2005, 06:06 PM
|
|||
|
|||
IIF A=x then B=A+1
....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 
|
|
#2
October 10th, 2005, 06:42 PM
|
|||
|
|||
|
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" wrote: ...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
|
|
#3
October 10th, 2005, 06:52 PM
|
|||
|
|||
|
yay! thanks a mill!
"Ofer" wrote: 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" wrote: ...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
|
|
#4
October 10th, 2005, 07:01 PM
|
|||
|
|||
|
Your welcome
-- I hope that helped Good luck "aaearhart" wrote: yay! thanks a mill! "Ofer" wrote: 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" wrote: ...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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
