Multiple field results

[ronchetc]

I am trying to build a query where I get results for a mutiple fields in a single field. As an example, I want to build a query called "Service", but I want to get results in a single column from the fields of "Service 1", "Service 2", etc. Is this possible??? If so, how?



Field 1 l "Service 1" l "Service 2" l "Service 3" l Field 4, etc.

[ajetrumpet]

use the concatenation operator:

[field1] & "|" & [field2]