Can you get access to add columns in Report Section?

[dave schurr]

i am using access 2000 and can not seem to get the data to total columns in
the Report section.....when i do it in quere i get totals but loss the fields
names????

dave

 

[Rick B]

To total the columns, just include an unbound field in your report with a
formula similar to the following:

=[Somefieldname] + [Someotherfieldname] + [somethirdfieldname]
etc.

You can do similar in a query and give the item a name that can be used in
your reports by adding a new column to your query with something like
this...

ColumnTotal: [Somefieldname] + [Someotherfieldname] + [somethirdfieldname]
etc.

 

[Bob Miller]

If the field in a column is named DataNos, then place a text box in the
appropriate footer (detail, page, etc.) in that coulmn and set the
Control Source to: =Sum([DataNos])

 

[Klatuu]

It can be done either way; however, if the back end data is on a server, then
doing it in the report is faster.

To total the columns, just include an unbound field in your report with a
formula similar to the following:

=[Somefieldname] + [Someotherfieldname] + [somethirdfieldname]
etc.

You can do similar in a query and give the item a name that can be used in
your reports by adding a new column to your query with something like
this...

ColumnTotal: [Somefieldname] + [Someotherfieldname] + [somethirdfieldname]
etc.


--
Rick B

i am using access 2000 and can not seem to get the data to total columns in
the Report section.....when i do it in quere i get totals but loss the
fields
names????

dave