How do I create a form that will add numbers in Access 2000

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am needing to create a form in Access 2000 that will total. Can anyone
tell me how to do this? I need several rows and columns to add up at the
bottom and across.
 
Hi R.

To add fields across a row, you need to use an expression either in the
ControlSource of the textbox showing the total, or in a calculated field in
your RecordSource query. If you also want to sum that total across the
rows, then use the calculated field option.
If it's possible for some of the contributing fields to be null (blank) then
use the Nz function to convert these to zero. For example:
RowTotal: Nz([Field1],0) + Nz([Field2],0) + Nz([Field3],0)

You can then bind a textbox in the row to the RowTotal field.

To sum the fields in a column, use the Sum function in the ControlSource of
a textbox in the form footer. For example:
=Sum([Field1])
or
=Sum([RowTotal])
 
Back
Top