Help with recalc!

[Guest]

I have a form that is based off a table that has a fields for mon rec, tues
rec, wed rec, etc.... On my form I have a unbound text box that I have the
calculation in it =Sum([MONDAY REC]+[TUESDAY REC]+[WEDNESDAY REC]+[THURSDAY
REC]+[FRIDAY REC]). This works except I need a running total to change when
a new amount is entered in any of these fields. I have tried the me.recalc,
and a couple of other things but it will not give me current amounts. I
haven't done this for awhile and so consider me a new user. Can just someone
explain to me where I put the me.recalc or what specifically I need to do to
get this to recalc automatically, yes step by step would be nice and greatly
appreciated. After doing this for a few days I believe I actually killed off
some brain cells so please be nice!!!!

 

[Al Campagna]

mgkaam,
Well, I wonder if that's really what you want to do. Let's look at some sample data
records..(I'll just use 3 days)
I set up a quick test form with entries like these...

Mon Tue Wed
2 6 3 = 11 ( = Mon + Tue + Wed )
3 4 9 = 16 ( = Mon + Tue + Wed )
1 5 3 = 9 ( = Mon + Tue + Wed )
--------------------
6 15 15 = 36 ( =Sum(Mon + Tue + Wed )

If you just want to add the 3 values you see on the form, use the = Mon + Tue + Wed
(which recalcs itself whenever a value is changed)
If you want to total ALL the values... across all the records... use =Sum(Mon + Tue +
Wed) (which needs a Refresh on the AfterUpdate event of each value).

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."