report totals

[cc]

I have a database tracking parking leases in a parking garage. The data
comes from two tables - one table has general information about companies
whose employees have parking leases, one table has more specific information
on the leases given to the employees of the various companies. The tables
are linked through the company key.

My report has been grouped by company, with summary information (total of
leases promised to a company and totals leases actually used by the company)
in the Group Header. The information about the actual individual lease
holders of each company is in the Detail.

In the Report Footer, I would like to sum the total number of parking spaces
promised to all of the companies. The applicable fields - [Reserved Spaces
Promised] and [Non-Reserved Spaces Promised] are from the company table.

I am hypothesizing two ways I might do this:

1. Put a text box in the Report Footer and use an expression in Properties
for the field that would sum the [Reserved Spaces Promised] and [Non-Reserve
Spaces Promised] fields from the Group Header section.

or

2. I might need to make a field in the Company table that sums the data from
the [Reserved Spaces Promised] and [Non-Reserved Spaces Promised] in that
table. Then, I would use that field in the Report Footer.

Could you please offer assistance? I am not very knowledgeable about
Access, so please suggest the easiest way. I would need to know that correct
expression to use if you suggest #1 above. Or, if #2 is the way to go, I
would need to know how, in Design View, to make a new field in a table that
would sum two other fields in that table. Or, possibly you have a third way
I should go.

Thank you very much for your help.

 

[Marshall Barton]

I have a database tracking parking leases in a parking garage. The data
comes from two tables - one table has general information about companies
whose employees have parking leases, one table has more specific information
on the leases given to the employees of the various companies. The tables
are linked through the company key.

My report has been grouped by company, with summary information (total of
leases promised to a company and totals leases actually used by the company)
in the Group Header. The information about the actual individual lease
holders of each company is in the Detail.

In the Report Footer, I would like to sum the total number of parking spaces
promised to all of the companies. The applicable fields - [Reserved Spaces
Promised] and [Non-Reserved Spaces Promised] are from the company table.

I am hypothesizing two ways I might do this:

1. Put a text box in the Report Footer and use an expression in Properties
for the field that would sum the [Reserved Spaces Promised] and [Non-Reserve
Spaces Promised] fields from the Group Header section.

or

2. I might need to make a field in the Company table that sums the data from
the [Reserved Spaces Promised] and [Non-Reserved Spaces Promised] in that
table. Then, I would use that field in the Report Footer.

Could you please offer assistance? I am not very knowledgeable about
Access, so please suggest the easiest way. I would need to know that correct
expression to use if you suggest #1 above. Or, if #2 is the way to go, I
would need to know how, in Design View, to make a new field in a table that
would sum two other fields in that table. Or, possibly you have a third way
I should go.

2) is not a viable approach. Storing totals in a table is a
violation of the rules of database normalization.

1) can be done using a running sum text box in the group
header. Add a text box named txtRunRsrvd to the group
header. Bind it to the [Reserved Spaces Promised] field and
set its RunningSum property to Over All. Then the report
footer text box can display the grand total by using the
expression =txtRunRsrvd

A different approach would be to create a query that
calculates all the grand totals and then use that as the
record source for a little subreport.

In this report, I think(?) that the running sum idea is
probably more appropriate.

 

[cc]

Your directions for #1 worked beautifully. Thank you.

I have a database tracking parking leases in a parking garage. The data
comes from two tables - one table has general information about companies
whose employees have parking leases, one table has more specific information
on the leases given to the employees of the various companies. The tables
are linked through the company key.

My report has been grouped by company, with summary information (total of
leases promised to a company and totals leases actually used by the company)
in the Group Header. The information about the actual individual lease
holders of each company is in the Detail.

In the Report Footer, I would like to sum the total number of parking spaces
promised to all of the companies. The applicable fields - [Reserved Spaces
Promised] and [Non-Reserved Spaces Promised] are from the company table.

I am hypothesizing two ways I might do this:

1. Put a text box in the Report Footer and use an expression in Properties
for the field that would sum the [Reserved Spaces Promised] and [Non-Reserve
Spaces Promised] fields from the Group Header section.

or

2. I might need to make a field in the Company table that sums the data from
the [Reserved Spaces Promised] and [Non-Reserved Spaces Promised] in that
table. Then, I would use that field in the Report Footer.

Could you please offer assistance? I am not very knowledgeable about
Access, so please suggest the easiest way. I would need to know that correct
expression to use if you suggest #1 above. Or, if #2 is the way to go, I
would need to know how, in Design View, to make a new field in a table that
would sum two other fields in that table. Or, possibly you have a third way
I should go.

2) is not a viable approach. Storing totals in a table is a
violation of the rules of database normalization.

1) can be done using a running sum text box in the group
header. Add a text box named txtRunRsrvd to the group
header. Bind it to the [Reserved Spaces Promised] field and
set its RunningSum property to Over All. Then the report
footer text box can display the grand total by using the
expression =txtRunRsrvd

A different approach would be to create a query that
calculates all the grand totals and then use that as the
record source for a little subreport.

In this report, I think(?) that the running sum idea is
probably more appropriate.