Total column in reports

[EHOWE]

I have a report with multiple different totals. I now want to add those
total for a grand total. I am very new at access so I need for easy and
understandable instructions. Thanks for the help

 

[Marshall Barton]

I have a report with multiple different totals. I now want to add those
total for a grand total. I am very new at access so I need for easy and
understandable instructions.

What are you trying to total?

A single column can be totaled using a report header/footer
text box with an expression =Sum(thefield)

If you are trying to total an calculation such as Price *
Quantity, then use =Sum(Price * Quantity)

If already have two colimns totaled in the report footer,
then you can add them using an expression =tot1 + tot2

 

[EHOWE]

What I have is a database where a checker goes in and enters the type of user
error. For example incorrect entry. I have 29 different user errors. I
want the report to show how many times each individual error occured and the
total of all the errors.

 

[Marshall Barton]

So what are the fields in the report's record source
table/query?

If your table is normalized, there is a single field with an
error type code. In this case, you should create a Totals
query that calculates the desired values:

SELECT errorcode, Count(*) As ErrCount
FROM thetable
GROUP BY errorcode

Then create a report that displays the query's data and use
this report as a subreport in your current report's footer
section.

 

[EHOWE]

There are tow of us working on this project, so I am not really sure. The
control source is =Sum(-[Incorrect Entry]). They are placed in the report
footer because we only needed 1 copy and was having porblems with multiples.

So what are the fields in the report's record source
table/query?

If your table is normalized, there is a single field with an
error type code. In this case, you should create a Totals
query that calculates the desired values:

SELECT errorcode, Count(*) As ErrCount
FROM thetable
GROUP BY errorcode

Then create a report that displays the query's data and use
this report as a subreport in your current report's footer
section.
--
Marsh
MVP [MS Access]

What I have is a database where a checker goes in and enters the type of user
error. For example incorrect entry. I have 29 different user errors. I
want the report to show how many times each individual error occured and the
total of all the errors.

 

[EHOWE]

I have finally figured it out thanks for the help

So what are the fields in the report's record source
table/query?

If your table is normalized, there is a single field with an
error type code. In this case, you should create a Totals
query that calculates the desired values:

SELECT errorcode, Count(*) As ErrCount
FROM thetable
GROUP BY errorcode

Then create a report that displays the query's data and use
this report as a subreport in your current report's footer
section.
--
Marsh
MVP [MS Access]

What I have is a database where a checker goes in and enters the type of user
error. For example incorrect entry. I have 29 different user errors. I
want the report to show how many times each individual error occured and the
total of all the errors.