Problems with totals on reports

[Paul]

Hi,

I'm trying to create a report that has a grand total of one of my fields in
a query, could anybody help please?

 

[Guest]

Insert a report footer in the report and in the report footer insert a
textbox and use =SUM([YourFieldNameGoesHere]) to total that field across the
report.

 

[Al Campagna]

Paul,
= Sum([YourField]) in the Report Footer would give the overall sum of YourField.

[YourFieldName] must be a bound, non-caclculated field, and that sum field name can not
be the same as the field name itself. ex. Name = SumOfYourField (right).... Name =
YourField (wrong)

 

[Paul]

Hi Al,

What do i do if the field is a calculated field?

Paul,
= Sum([YourField]) in the Report Footer would give the overall sum of
YourField.

[YourFieldName] must be a bound, non-caclculated field, and that sum
field name can not be the same as the field name itself. ex. Name =
SumOfYourField (right).... Name = YourField (wrong)
--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

Hi,

I'm trying to create a report that has a grand total of one of my fields
in a query, could anybody help please?

 

[Guest]

You can place the calculation in a SUM. So if you have a price and quantity
field, the line item is calculated as
=[Price]*[Quantity]

In the Report footer insert a text box and use the following formula:

=SUM([Price]*[Quantity])

--
Kevin Backmann

Hi Al,

What do i do if the field is a calculated field?

Paul,
= Sum([YourField]) in the Report Footer would give the overall sum of
YourField.

[YourFieldName] must be a bound, non-caclculated field, and that sum
field name can not be the same as the field name itself. ex. Name =
SumOfYourField (right).... Name = YourField (wrong)
--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

Hi,

I'm trying to create a report that has a grand total of one of my fields
in a query, could anybody help please?

 

[Paul]

Hi Kevin,

Can I post you my database on here for you to take a look at it quickly?

Regards,

Paul E.

You can place the calculation in a SUM. So if you have a price and
quantity
field, the line item is calculated as
=[Price]*[Quantity]

In the Report footer insert a text box and use the following formula:

=SUM([Price]*[Quantity])

--
Kevin Backmann

Hi Al,

What do i do if the field is a calculated field?

Paul,
= Sum([YourField]) in the Report Footer would give the overall sum
of
YourField.

[YourFieldName] must be a bound, non-caclculated field, and that sum
field name can not be the same as the field name itself. ex. Name =
SumOfYourField (right).... Name = YourField (wrong)
--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

Hi,

I'm trying to create a report that has a grand total of one of my
fields
in a query, could anybody help please?

 

[Guest]

I won't be able to get the database through the firewall at my current
location, but if you look at my profile you can pretty much figure out my
home email address. I won't be able to review it until sometime this evening
though.
--
Kevin Backmann

Hi Kevin,

Can I post you my database on here for you to take a look at it quickly?

Regards,

Paul E.

You can place the calculation in a SUM. So if you have a price and
quantity
field, the line item is calculated as
=[Price]*[Quantity]

In the Report footer insert a text box and use the following formula:

=SUM([Price]*[Quantity])

--
Kevin Backmann

Hi Al,

What do i do if the field is a calculated field?


Paul,
= Sum([YourField]) in the Report Footer would give the overall sum
of
YourField.

[YourFieldName] must be a bound, non-caclculated field, and that sum
field name can not be the same as the field name itself. ex. Name =
SumOfYourField (right).... Name = YourField (wrong)
--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

Hi,

I'm trying to create a report that has a grand total of one of my
fields
in a query, could anybody help please?

 

[Al Campagna]

Paul,
Did you try Kevin's solution?
Another solution is to create a calculated field in the query behind the report.
Take an empty column in the Query Design Grid.
In the Field, put this...
LineTotal : [Price] * [Qty]
LineTotal is now a "bound" field, and can be placed on the report in place of your
old calculated field of = [Price] * [Qty]
Now...
= Sum([LineTotal])
will add up all the individual line items in any GroupFooter, or ReportFooter.
--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

Hi Kevin,

Can I post you my database on here for you to take a look at it quickly?

Regards,

Paul E.

You can place the calculation in a SUM. So if you have a price and quantity
field, the line item is calculated as
=[Price]*[Quantity]

In the Report footer insert a text box and use the following formula:

=SUM([Price]*[Quantity])

--
Kevin Backmann

Hi Al,

What do i do if the field is a calculated field?


Paul,
= Sum([YourField]) in the Report Footer would give the overall sum of
YourField.

[YourFieldName] must be a bound, non-caclculated field, and that sum
field name can not be the same as the field name itself. ex. Name =
SumOfYourField (right).... Name = YourField (wrong)
--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

Hi,

I'm trying to create a report that has a grand total of one of my fields
in a query, could anybody help please?