columns in detail area of access report

[DBTrueheart]

I have created an Access report to show training for an employee filtered by
the employee id. To minimize paper use, I would like the detail section ONLY
of the report to format as columns. I tried inserting a subreport but the
entries repeated an enormous number of times... a two page report went to
27002+ pages. Not good. Please help.

 

[Duane Hookom]

If you are adding a subreport of details, you must remove the "details" level
from the main report. The individual training records table(s) should not be
included in the main report's record source.

 

[DBTrueheart]

Duane, I am not sure what you mean by remove the "details" level. I cannot
actually remove the details section from the physical report and I have
nothing in the details area of my report except the subreport. Below is the
SELECT statement for my report:
SELECT Employees.Employee, [Completed Classes].Class, [Completed
Classes].[Date Completed], Employees.EmployeeID, Employees.Status,
Employees.Grade, Employees.GS, Employees.[Hire Date], Employees.Department,
Employees.[Position Title], Employees.Orientation, Employees.WCCS,
Employees.[Active Duty], Employees.[Training Needed] FROM Employees INNER
JOIN [Completed Classes] ON Employees.EmployeeID=[Completed
Classes].EmployeeID WHERE (((Employees.EmployeeID) Like "*" & [Employee ID] &
"*") AND ((Employees.Status)="Active"));

When opened, the report asks for the employee id.
Thank you,
Dana

 

[Duane Hookom]

By "details", I meant the detail level of your report's record source. I
expect this is the [Completed Classes] table/query. Your main report might
contain only the unique, active employees and the subreport contains the
training records. You would set the link master/child properties to the
EmployeeID fields.

--
Duane Hookom
Microsoft Access MVP

Duane, I am not sure what you mean by remove the "details" level. I cannot
actually remove the details section from the physical report and I have
nothing in the details area of my report except the subreport. Below is the
SELECT statement for my report:
SELECT Employees.Employee, [Completed Classes].Class, [Completed
Classes].[Date Completed], Employees.EmployeeID, Employees.Status,
Employees.Grade, Employees.GS, Employees.[Hire Date], Employees.Department,
Employees.[Position Title], Employees.Orientation, Employees.WCCS,
Employees.[Active Duty], Employees.[Training Needed] FROM Employees INNER
JOIN [Completed Classes] ON Employees.EmployeeID=[Completed
Classes].EmployeeID WHERE (((Employees.EmployeeID) Like "*" & [Employee ID] &
"*") AND ((Employees.Status)="Active"));

When opened, the report asks for the employee id.
Thank you,
Dana
--
"Success is the ability to go from one failure to another with no loss of
enthusiasm." - Winston Churchill

If you are adding a subreport of details, you must remove the "details" level
from the main report. The individual training records table(s) should not be
included in the main report's record source.

 

[DBTrueheart]

OkeeDokee, I kinda thought that's what you meant, but when I do that my
report goes from 3 pages to (now) 207 pages. I don't know enough to alter the
SQL statement or even how to alter it. I know this can be done. Do I need to
start over? Make a new report?
--
"Success is the ability to go from one failure to another with no loss of
enthusiasm." - Winston Churchill

By "details", I meant the detail level of your report's record source. I
expect this is the [Completed Classes] table/query. Your main report might
contain only the unique, active employees and the subreport contains the
training records. You would set the link master/child properties to the
EmployeeID fields.

--
Duane Hookom
Microsoft Access MVP

Duane, I am not sure what you mean by remove the "details" level. I cannot
actually remove the details section from the physical report and I have
nothing in the details area of my report except the subreport. Below is the
SELECT statement for my report:
SELECT Employees.Employee, [Completed Classes].Class, [Completed
Classes].[Date Completed], Employees.EmployeeID, Employees.Status,
Employees.Grade, Employees.GS, Employees.[Hire Date], Employees.Department,
Employees.[Position Title], Employees.Orientation, Employees.WCCS,
Employees.[Active Duty], Employees.[Training Needed] FROM Employees INNER
JOIN [Completed Classes] ON Employees.EmployeeID=[Completed
Classes].EmployeeID WHERE (((Employees.EmployeeID) Like "*" & [Employee ID] &
"*") AND ((Employees.Status)="Active"));

When opened, the report asks for the employee id.
Thank you,
Dana
--
"Success is the ability to go from one failure to another with no loss of
enthusiasm." - Winston Churchill

If you are adding a subreport of details, you must remove the "details" level
from the main report. The individual training records table(s) should not be
included in the main report's record source.
--
Duane Hookom
Microsoft Access MVP


:

I have created an Access report to show training for an employee filtered by
the employee id. To minimize paper use, I would like the detail section ONLY
of the report to format as columns. I tried inserting a subreport but the
entries repeated an enormous number of times... a two page report went to
27002+ pages. Not good. Please help.

 

[Duane Hookom]

You really need to be able to identify the Record Sources of your reports. I
can only guess that your subreport has the [Completed Classes] as part of its
record source. The main report should have only [Employees] as the record
source (or query based on Employees). Set the Link Master/Child properties to
EmployeeID.

If you can't figure this out, come back with the record sources and the link
properties.
--
Duane Hookom
Microsoft Access MVP

OkeeDokee, I kinda thought that's what you meant, but when I do that my
report goes from 3 pages to (now) 207 pages. I don't know enough to alter the
SQL statement or even how to alter it. I know this can be done. Do I need to
start over? Make a new report?
--
"Success is the ability to go from one failure to another with no loss of
enthusiasm." - Winston Churchill

By "details", I meant the detail level of your report's record source. I
expect this is the [Completed Classes] table/query. Your main report might
contain only the unique, active employees and the subreport contains the
training records. You would set the link master/child properties to the
EmployeeID fields.

--
Duane Hookom
Microsoft Access MVP

Duane, I am not sure what you mean by remove the "details" level. I cannot
actually remove the details section from the physical report and I have
nothing in the details area of my report except the subreport. Below is the
SELECT statement for my report:
SELECT Employees.Employee, [Completed Classes].Class, [Completed
Classes].[Date Completed], Employees.EmployeeID, Employees.Status,
Employees.Grade, Employees.GS, Employees.[Hire Date], Employees.Department,
Employees.[Position Title], Employees.Orientation, Employees.WCCS,
Employees.[Active Duty], Employees.[Training Needed] FROM Employees INNER
JOIN [Completed Classes] ON Employees.EmployeeID=[Completed
Classes].EmployeeID WHERE (((Employees.EmployeeID) Like "*" & [Employee ID] &
"*") AND ((Employees.Status)="Active"));

When opened, the report asks for the employee id.
Thank you,
Dana
--
"Success is the ability to go from one failure to another with no loss of
enthusiasm." - Winston Churchill


:

If you are adding a subreport of details, you must remove the "details" level
from the main report. The individual training records table(s) should not be
included in the main report's record source.
--
Duane Hookom
Microsoft Access MVP


:

I have created an Access report to show training for an employee filtered by
the employee id. To minimize paper use, I would like the detail section ONLY
of the report to format as columns. I tried inserting a subreport but the
entries repeated an enormous number of times... a two page report went to
27002+ pages. Not good. Please help.