concatenate field names

[Exodus]

I have
Field1
Field2
Field3

I need to concatenate these three fields into one but for each record the order can be different. What I want to do is have another field in the table to store the concatenation order as the field names not the field values.
I also need to display the concatenated field as the actual field values and not field names in a form or a report

So if field4 was the concatenated field store it would store the information like this
[Field1] & " " & [Field3] & " " & [Field2]

In a form or a report
Field4 should show as Values of those fields
Monkey Dog Cat

 

[GinaWhipp]

Hmm, you're going to have to play with some code, this should get you started...
http://allenbrowne.com/func-concat.html