Merge Column Data

  • Thread starter Thread starter dan
  • Start date Start date
D

dan

Hi Steve,

I have a table with four fields of differant decisions to
treat based on what type of treat they are having. i want
to create just one fields with all the dec to treat
together, cos I know where one is populated the others
will be null. I have this syntax but it is not
working....does anybody have any ideas?

DectoTreat: IIf([field24a] Is Null,[field25a],IIf
([field25a] Is Null,[field28a],IIf([field28a] Is Null,
[field29a],[field24a])))

Cheers
 
Create a query based on your table and add an extra field named DectoTreat.
The field name should look like this:
FinalTreat:[Field24A]&[Field25A]&[Field28A]&[Field29A]
 
Back
Top