Summing items on a form????

[pdbowling]

Hi all, I have a table with 42 columns. The key, 40 data values, and a total field. Pretty cluttered I know, but I didn't design it. I made a form with it and I'm trying to get the form to autofill the total field as the data values are entered. Any suggestions on how to do this? I already tried to string all forty together in the expression builder but they wouldn't fit.
Thanks everyone.
P

 

[geaker]

Try DSum. It worked for me an a subform.

Gerald

 

[pdbowling]

DSum appears to work down a column. I was looking at summing across a row.

Key......Valu1.....Valu2.....Total
xxx.......1.........1.........2
yyy.......1.........2.........3
zzz.......2.........2.........4

My form has a field, currently blank, bound to Total...
Sorry to be a hassle.
PB

 

[Nubster]

Try this for your total...

I would use a text box and enter this formula:

=Sum([Valu1]+[Valu2]+[Valu3])

Hope it works

Ray

 

[pdbowling]

Hey thanks nubster/geaker. I ended up writing it in the code for a command button. I made it so they had to use the command button to go to the next record so the code would always execute. It was just that I had so many items to add together that the buffer for the controls was running out of space. Code has no such problems. I really appreciate your efforts. Thank you.
PB

 

[Nubster]

Your welcome )