Frustrated with Form

  • Thread starter Thread starter Andrew Tatum
  • Start date Start date
A

Andrew Tatum

Alright, I have a form that contains three subforms. In the main form,
I made a text box to total up the BookedMsg field from the Invoicing
Subforum. For some reason or another, I constantly get a #Error. I just
don't get it. Below is my control source. Any assistance is greatly
appreciated!

=Sum([Invoicing Subform].Form!BookedMsg)

Sincerely,
Andrew Tatum
 
In the sub form, form footer, you can create a text field that sum the
BookedMsg
=Sum([BookedMsg])

in the main form, create a fiel to refer to the field you created above
=[Invoicing Subform].Form![WriteHereSumBookedMsgFieldName]
 
Excellent! That solved my first problem. I then came across something
else... that relates to that problem.

I have a Net Total field that takes a "Rejected" field and subtracts it
from a "Accepted" field.

So... Net Total = Accepted-Rejected

When I try to get a TOTAL of the Net Total... I get an error.

I do the same thing, I put a field in the footer and ask for a SUM of
Net Total. However, I get a #Error

=Sum([NetTotal])

..... on a side note, it would be really nice if Access told us more
about error... like what causes the error.

Any idea on how to solve this issue?

I truly appreciate your help!
 
You should get the total of the formula

=Sum([Accepted]-[Rejected])

The Sum works on the name of the fields in the table and not on the name of
the text boxes in the form.
 
Back
Top