Totals

  • Thread starter Thread starter sheetal
  • Start date Start date
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
 
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).
 
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
 
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
 
Back
Top