Horizontal Records.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, All.
I have an Employee table linked with a Skills table via
EmployeeNumber.
The Skills table looks like:
RecNoID EmplNum SkillCode

The standard Access report comes out like:

12345 Doe, John
Skill1
Skill2
Skill3
etc.

Some employees have up to 30 skills. To save paper space I want to print a
report that looks like this:

12345 Doe, John Skill1 Skill2 Skill3 Skill4 Skill5 .....etc.

Any ideas? Upon report open, should I load all the skills into a Skills Array?

Thanks in advance,

Will
 
One no code method is to remove the Skills table from the report. Create a
multiple column skills subreport. Place the subreport in the Employee main
report and link on the EmplNum. Make sure the subreport columns are set to
display Across Then Down.
 
Awesome! I never even thought about a subreport. Thanks much, Duane!


Duane Hookom said:
One no code method is to remove the Skills table from the report. Create a
multiple column skills subreport. Place the subreport in the Employee main
report and link on the EmplNum. Make sure the subreport columns are set to
display Across Then Down.

--
Duane Hookom
MS Access MVP
--

Will_in_Canada said:
Hello, All.
I have an Employee table linked with a Skills table via
EmployeeNumber.
The Skills table looks like:
RecNoID EmplNum SkillCode

The standard Access report comes out like:

12345 Doe, John
Skill1
Skill2
Skill3
etc.

Some employees have up to 30 skills. To save paper space I want to print a
report that looks like this:

12345 Doe, John Skill1 Skill2 Skill3 Skill4 Skill5 .....etc.

Any ideas? Upon report open, should I load all the skills into a Skills
Array?

Thanks in advance,

Will
Click to expand...
Click to expand...
 
Back
Top