IIf and Trim

  • Thread starter Thread starter Chi
  • Start date Start date
C

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
 
Hi Duane,

It works perfectly! Thank you so much.
Chi

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

--
Duane Hookom
Microsoft Access MVP


Chi said:
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
Click to expand...
Click to expand...
 
Back
Top