Merge Column Data

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
 
G

Guest

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top