By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,483 Members | 1,449 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,483 IT Pros & Developers. It's quick & easy.

add function in access

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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)
Nov 13 '05 #2

P: n/a
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)

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.