Is it possible so that a user can select the fields and order of concatenation in a table?

For example I have 3 fields, Name, Pet, Equipment.

For example the user may wish to concatenate the fields in this order Name Pet Equipment or in this order Equipment Pet Name.

TJ,

Your request doesn't give us any context. What is the user doing with the results? Is it part of an email? A report?

Barbara

The final result would be the ability to sort and summarize by these concantenated fields. What I was hoping to do was provide 3 blank fields for the user to fill in with the field names they want to concantenate by.

Sorry, I need more details. Summarize? Can you give an example?

I think he's trying to say that he would like his users to be able to sort by whichever his users choose, for example:

Sort by (field one(Name), field two(Pet), field three(Equipment)) or if they choose

Sort by (field one(Equipment), field two (Name, field three (Pet), and so on.

He wants the user to be able to sort in order by whatever information that they add to the fields. Not sure why he needs this.

Edited March 30, 201015 yr by Guest

But you didn't guess at his need to "summarize."