summing text boxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!!!
 
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."
 
I was just about to respond when you made me realise I had a stupid moment.
I was using the wrong field names.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating a text box 9
Sum Calculated Field Question 1
Sum 2
Access Sum function in an Access Form 1
Sums from two criteria 4
sum combo box based on other combo box 2
Getting #Error, nothing, and a delay for =Sum([field]) in a subfor 2
Text field in Subform 1

Back
Top