summing text boxes

S

scubadiver

I have a subform that has a number of text boxes for different types of
holiday and I have created a new text box that totals these text boxes. The
problem I have come across is that the total isn't restricted to a single
record. Absences in the next record gets added to the total (make sense?).

What is the work around?

Cheers!!!!
 
A

Al Campagna

scubadiver,
Please describe each of the fields, sample values from those fields, the expected
result, and the calculation you have to sum them.
--
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."
 
S

scubadiver

I was just about to respond when you made me realise I had a stupid moment.
I was using the wrong field names.
 
Top