Grouping a report my individuals

  • Thread starter Thread starter MAX
  • Start date Start date
M

MAX

Hello,

I am having a problem with grouping in a report.
I have 2 Tables: [OCPAC CORRESPONDENCE LOG] AND [OCPAC FEI
Employee Codes] which are joined by the field: [ACTION BY]

Under the [OCPAC FEI Employee] table I have a [Full
Name]. In the report I wanted to be able to pull in all
records that included the [ACTION BY] and group it by the
individual. I can go in and edit the table to include all
possiblities, but that could become a nightmare.
Basically in [OCPAC CORRESPONDENCE LOG] the [ACTION BY]
can be MY, or MY/TJ or, MY/TJ/HM. What I wanted to do is
create a report that shows the records for each individual
reguardless if it is shared. So for those records that
have shared responsibilty (MY/TJ) the report would have
the record under both MY and TJ.

Any Ideas??

Max
 
Unfortunately, the un-normalized design of your database makes your job more
difficult. You should have had the individuals who performed actions in a
separate, related table, one per record, joined to the main table by a
junction table with a foreign key to each.

You describe an [ACTION BY] field that can include multiple values --
multivalue fields are a violation of good relational database design
principles, _because_ they make what you want to do more difficult.

It would be trivial to create a Query including the three tables Log,
junction, and Employees, join them properly, and base your report on that
query. I suggest you consider a redesign so that your future enhancements
and maintenance will be less of a burden.

Larry Linson
Microsoft Access MVP
 
Back
Top