Row Total (not column total) in Reports

[mzbliz]

I have four fields for each month of the year 2008. I can sum the bottom of
each column to get a total for each field for the year. I need to create a
row total in the detail sections that will give me a sum for the four fields
for each month.

 

[Jeff Boyce]

You may have posted to the wrong newsgroup. This newsgroup supports the use
of Microsoft Access, a relational database.

What you are describing sounds more like what you'd do with a spreadsheet.

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[mzbliz]

Jeff,

I am using Microsoft Access. According to the users manual I have I should
be able to create a text box in reports and enter the data as =[fieldname1] +
[fieldname2] + [fieldname3] to get a row total.

Can you help with this?

Thanks, mzbliz

 

[mzbliz]

Regina,

That's exactly what I'm doing, but I don't get the row total. According to
the user manual I have it tells me I can enter it like you described in the
detail section of the report.

Mzbliz

You should be able to do [fieldnameA]+[FieldnameB]+[fieldnameC] on your
report. I have several reports that I have set up in Access that I have row
totals and row sums that I have set up that use the above setup and/or
[fieldnameA]*[fieldnameB] as an example: Tonnage*price = $cost per load

I have four fields for each month of the year 2008. I can sum the bottom
of
each column to get a total for each field for the year. I need to create
a
row total in the detail sections that will give me a sum for the four
fields
for each month.

 

[John Spencer]

Add a control to the report with a name like txtRowSum
Set its source to
= NZ(FieldA,0) + NZ(FieldB,0) + NZ(FieldC,0) + NZ(FieldD,0)

THe NZ handles values that are null and converts them to zero.

If your fields are not numeric, but are text you might need to use
CDbl(NZ(FieldA)) to force the arithmetic operation.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County