add function in access

[Pisa Phothisene]

Hello,
I have created 4 rows rowA, rowB, roC, ToatlRow. Rows A,B,C has a
numeric value. I would like to setup a LostFocus on rowA,B,C so that
TotolRow would automatically display a sum of the 3 rows. Is it
possible? and please show sample code if VB or Macros is require. I
tried creating Expression but did not have any luck.

Thanks

[Salad]

Pisa Phothisene wrote:

Hello,
I have created 4 rows rowA, rowB, roC, ToatlRow. Rows A,B,C has a
numeric value. I would like to setup a LostFocus on rowA,B,C so that
TotolRow would automatically display a sum of the 3 rows. Is it
possible? and please show sample code if VB or Macros is require. I
tried creating Expression but did not have any luck.

Thanks

Let's assume you have columns in rowA, B, and C. One of the fields is
called Num1. If you have a field in the TotRow, the control source
could be
=Sum([Num1])
Do that for the rest.

If your rows/columns have different fields, you could do
=Sum(RowANum + RowBNum + RowBNum)

[Pisa Phothisene]

THANK! That worked like a charmed....
Salad <oi*@vinegar.com> wrote in message news:<MX*****************@newsread1.news.pas.earth link.net>...

Pisa Phothisene wrote:

Hello,
I have created 4 rows rowA, rowB, roC, ToatlRow. Rows A,B,C has a
numeric value. I would like to setup a LostFocus on rowA,B,C so that
TotolRow would automatically display a sum of the 3 rows. Is it
possible? and please show sample code if VB or Macros is require. I
tried creating Expression but did not have any luck.

Thanks

Let's assume you have columns in rowA, B, and C. One of the fields is
called Num1. If you have a field in the TotRow, the control source
could be
=Sum([Num1])
Do that for the rest.

If your rows/columns have different fields, you could do
=Sum(RowANum + RowBNum + RowBNum)