Summary report question

[Susan]

Suppose you have an Access report which prints detail and summary totals for
departments and employees.

For example:

employee dept sales amt

John 10 200
Bess 10 300
Henry 10 500
3 ? 1000

Bill 20 10
1 ? 10

Abigail 40 50
1 ? 50

I can right click the blank area in the detail and select no for visible and
I will see the summary only on the report. But I would like to see the
actual dept number on the summary lines so I would know what the dept is .
How do you achieve this?

 

[Mark Andrews]

Since all detail lines should have the same dept number, use:
=Min(dept)
or
=Max(dept)

 

[Susan]

I should not have used numbers in my example-- what if the dept is
"Accounting", or "Information Services", "Human Resources"?

 

[Tom Wickerath]

Hi Susan,

In report design view, click on View | Sorting and Grouping. Select the
Department field. Set the Group Header and Group Footer to Yes.

Add the Department field to the Department Header and Department Footer
sections. Add the Employee and Sales Amounts fields to the Detail section.
Set the visible property for the Department Header and the Detail sections to
No.

Copy the Sales Amount field to the Department Footer section. Change the
Control Source for this text box to: =Sum([Sales Amount]). Set a currency
format.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Susan]

Thank you very much!

Hi Susan,

In report design view, click on View | Sorting and Grouping. Select the
Department field. Set the Group Header and Group Footer to Yes.

Add the Department field to the Department Header and Department Footer
sections. Add the Employee and Sales Amounts fields to the Detail section.
Set the visible property for the Department Header and the Detail sections
to
No.

Copy the Sales Amount field to the Department Footer section. Change the
Control Source for this text box to: =Sum([Sales Amount]). Set a currency
format.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

Suppose you have an Access report which prints detail and summary totals
for
departments and employees.

For example:

employee dept sales amt

John 10 200
Bess 10 300
Henry 10 500
3 ? 1000

Bill 20 10
1 ? 10

Abigail 40 50
1 ? 50

I can right click the blank area in the detail and select no for visible
and
I will see the summary only on the report. But I would like to see the
actual dept number on the summary lines so I would know what the dept is
.
How do you achieve this?