Grouping for same information?

  • Thread starter Thread starter SEM
  • Start date Start date
S

SEM

I am attempting to group where the names of individuals
appear in different records and different fields.

See below...

Group where
Field1:Name of Person1, Field2:Name of Person2, and
Field3:Name of Person3
are the same (=)
but for different records

For record1, Field1:Smith,F.
For record2, Field2:Smith,F.
But the report displays grouped information for the
individual irrespective of the record...

Is this possible without coding? If you need more of an
explanation, please let me know!

Any assistance is greatly appreciated!
 
Your table is not normalized. This will continually cause issues with
queries and other development. You can use a UNION query to normalize you
data
SELECT [Field1] as Person, 1 as PersonNum
FROM tblYourSpreadsheet
UNION All
SELECT [Field2], 2
FROM tblYourSpreadsheet
UNION All
SELECT [Field3], 3
FROM tblYourSpreadsheet;

You may need to add in other fields. You can build a query from the result
that groups by Person.
 
Back
Top