[AccessD] another IIF statement question

Fri Mar 5 09:58:35 CST 2004

Hi Oleg

> I have 3 columns - if one contains a record the other two are blank; and I
> an trying to combine them 3 in one column. I was able to combine contest
> of 2 columns --

> (IIF(NOT isNull([Ron Data mid].[SW_Date_Closed]),  [Ron Data
> mid].[SW_Date_Closed],[OW_Date_Closed])) AS W_Date_Closed

How about:

  [Ron Data mid].[SW_Date_Closed] &
  [Ron Data mid].[SW_Date_Closed] &
  [OW_Date_Closed] AS W_Date_Closed

/gustav