Grouping In Query

[Van]

I have a table that has ten columns of simular information. I need to
combine the information and group it. What is the best way for me to
do this?

 

[Guest]

I need to combine the information and group it.
When you say 'combine' do you mean to concatenate the fields?
You can do that like this --
[Field1] & " - " & [Field2] & " - " & [Field3] & " - " & [Field4]

When you say 'group' do you mean to put all similar records one below the
other?
This can be done with sorting.

 

[John Vinson]

I have a table that has ten columns of simular information.

Then I suspect that you have a misdesigned table. Is this actually a
one to many relationship embedded within each record?

I need to
combine the information and group it. What is the best way for me to
do this?

Please give an example of the data and how you would like it grouped.
I can't visualize just what you mean by the question.

John W. Vinson[MVP]