Totals

S

sheetal

Is there a way that I can calculate totals horizontally in a report? I
can calculate them vertically (down wards) but not across. Also, is
there a way that I can total more than one field? Please help me with
the code for this.

Thanks

Sheetal
 
D

Duane Hookom

Totalling across generally suggests an un-normalized database. You can add
numeric fields across with an expression like:
=[FldA] + [FldB] + [FldC]
If you have nulls in any fields, you will need to use Nz([FldA],0).
 
S

sheetal

Hi this is great - its doing what I want it to do in access, but when
export the table from access report to excel spreadsheet, the resul
appears in the wrong column. Is there a way I can control thi
problem?

Also how can I add up horizontally in a query, or is it better to do i
in a report?

Thanks so much

Sheeta
 
S

sheetal

Hi this is great - its doing what I want it to do in access, but when
export the table from access report to excel spreadsheet, the resul
appears in the wrong column. Is there a way I can control thi
problem?

Also how can I add up horizontally in a query, or is it better to do i
in a report?

Thanks so much

Sheeta
 
Top