IIf and Trim

[Chi]

Hi,

I use IIf([ReserveDate] Is Null,Null,([ReserveDate] & " & " &
[ReserveDateTo])) to display ReserveDate & ReserveDateTo if ReserveDate is
Null. It works fine.

However, when ReserveDate has value, it displayed with &.

Ex: 12/22/08 &.

Would you please show me how to take the “&†off?

Thanks
Chi

 

[Duane Hookom]

Try:
[ReserveDate] & IIf(IsNull([ReserveDateTo]),Null," & " & [ReserveDateTo])

 

[Chi]

Hi Duane,

It works perfectly! Thank you so much.
Chi

Try:
[ReserveDate] & IIf(IsNull([ReserveDateTo]),Null," & " & [ReserveDateTo])

--
Duane Hookom
Microsoft Access MVP

Hi,

I use IIf([ReserveDate] Is Null,Null,([ReserveDate] & " & " &
[ReserveDateTo])) to display ReserveDate & ReserveDateTo if ReserveDate is
Null. It works fine.

However, when ReserveDate has value, it displayed with &.

Ex: 12/22/08 &.

Would you please show me how to take the “&†off?

Thanks
Chi

 

[Marshall Barton]

I use IIf([ReserveDate] Is Null,Null,([ReserveDate] & " & " &
[ReserveDateTo])) to display ReserveDate & ReserveDateTo if ReserveDate is
Null. It works fine.

However, when ReserveDate has value, it displayed with &.

Ex: 12/22/08 &.

Would you please show me how to take the “&” off?

IIf([ReserveDate] Is Null, Null, [ReserveDate] & (" & " +
[ReserveDateTo]))