Grouping In Query

  • Thread starter Thread starter Van
  • Start date Start date
V

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?
 
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.
 
I have a table that has ten columns of simular information.
Click to expand...

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?
Click to expand...

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]
 
Back
Top