Well I am using continuous form, every day we count our register, and at the end of the day when we recount it, we input it into the form, and it makes all the calculations for the checks credit cards, and takes all that and subtracts the invoice total from it, to see if we are short or over.
And I would like to put a running total of money collected in the register and invoice totals so we can see how it equals out.
Thank you very much I have it working. Works pretty good too.
Will this work on a field that has calculations in it. Like I have in my Registers Total field I have =[Pennies]+[Nickels]+ etc... and all that adds up just fine. Will Sum work on that field, or not because it is a calculated field?
Thank you very much for replying quickly.
I will have to keep trying on the sum thing. I am very new to this, and it was a wonder that I even was able to get a form running doing what I needed it to do.
I have tried to run a sum in form footer doing the Sum(pennies + nickels + dimes) and it didn't work, and I tried it like =Sum(pennies + + nickels + dimes)
it didn't work,
I also tried =Sum([Pennies]+[Nickels]+[Dimes]) and it didn't work either
Well, this my last attempt at trying to figure it out
this is what I was putting in control source the last time I did it
I left it with the default Text label because it was just a simple form
The other time I tried
=Sum(Text72 + Text74)
Then I tried
Sum(Text72 + Text74)
Then I tried
I get an #error in the field when I try all these