Totals Row in Datasheet

[gray]

Hi

Access 2002
WinXPPro

I have a form presented to the user in datasheet format. It has 3 "columns" containing currency . Does anyone know if it is possible to place a row at the bottom of the datasheet which contains the sum of the columns.... a' la spreadsheets? ....(with a built-in function rather then masses of coding, that is)

Thanks

 

[qdogfball]

Couldn't you create a report and let the users click a button to see the report with the sums?

No coding involved there ( with use of wizards!)

 

[GolferGuy]

If you make the datasheet a subform, the it's parent can have a control in the Form Footer that could give you the total of each column. The ControlSource of the "total" text box would follow this sample.

=DSum("Field01",  "tblORqryFromRecordSource", "SelectionField=" & fldFilterFieldForDataSheet)

I have tried to be descriptive of what to change these names I have used to what they represent in this sample. The third parameter to DSum() (Look up DSum in Access help) is the criteria that limits the records to be included in the sum. Whatever filter you use on the datasheet needs to be matched in this parameter to DSum.

 

[gray]

Hi Gents

Thanks for the tips... I shall be experimenting! Rgds