Displaying totals in reports from forms

[Guest]

I am new to access. I have a form that contains multiple totals and formulas.
The form will display the totals as needed however when I try to create a
report
to see those same totals all I get is a blank space.

Can someone please tell me what I'm doing wrong? Again I'm limited in
knowledge in access so please be patience with my learning curve.

Example:

I have 12 fields (ActualCount1 thru ActualCount12)
In these fields I have a formula to give me an actual count of other entered
numbers. Again on the form it will display my totals without error.

But when I try to do a report (ActualCount) is blank.

 

[Duane Hookom]

Need more information. Where and what are the formula? Where are you
attempting to show the totals in the report (section name)? What are the
fields in your report's record source?

 

[Guest]

In the formula’s I’m adding taking a beginning and ending chk number to get a
total number of checks printed.
=[Ending Check Number]-[Beginning Check Number]+1

I have a total of 12 totals that I call (ActuatlCount)
At the bottom of the form I have a field (Total Actual Count Day) that adds
up all
12 entries for one combined total:
=Sum([ActualCount])+nz([actual count])+nz([actual count2])+nz([actual
count3])+nz([actual count4])+nz([actual count5])+nz([actual
count6])+nz([actual count7])+nz([actual count8])+nz([actual
count9])+nz([actual count10])+nz([actual count11])+nz([actual count12])

In the report I just want to list the combined actual count and not each
actual count and then the total.

I hope this makes sense… thank you for your help

 

[Guest]

I see where other run queries for totals. is that something I should do
before trying to create a report? Also in doing a query how do I get it to
pull a total that only shows in the form but not in the tables?

 

[Duane Hookom]

Again, what are the fields in your report's record source? You state you
have "12 totals" but we don't know if these are fields in your report's
record source or what.

Is there a good reason why you have seemingly repeating fields? Is this the
result of a crosstab?

 

[Guest]

Again my apologies, the fields in my record source/table are:

ActualCount
ActualCount2
ActualCount3
ActualCount4
ActualCount5
ActualCount6
ActualCount7
ActualCount8
ActualCount9
ActualCount10
ActualCount11
ActualCount12
Each of these has a formula (=[Ending Check Number]-[Beginning Check Number]+1
Taking the ending chk and begin chk to give me an actual count for that job
1of12

The reason for having 12 is management. They want the input form to match
the paper formed that is currently used.

 

[Duane Hookom]

Again, this isn't clear since you suggest each of the "Actual..." has a
formula beginning with "=". This would suggest that your "Actual..." are
names of text boxes in your report rather than columns/fields in your
report's record source.

BTW: it is not good design to create table structures based on matching
paper forms. Table structures should not be dependent on user interface.