If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
Access 97 - Simple Calculation
So how does the formula work in all instances save where the result is zero?
"Douglas J. Steele" wrote: As I already said, you cannot put formulae into text boxes. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Anthony1205" wrote in message ... I am sorry if I used the wrong terminology, but my initial post is the correct position, namely, "My form has three fields that I use for calculation: There is the [Fee] field representing what is charged, [Amount] field representing what is paid, and the [Balance] field which represents what is owing and is the field used for the actual calculation." The formula has been entered directly into the box under the label in form design view. Hope that clarifies things. Sorry for the confusion. Anthony |
#12
|
|||
|
|||
Access 97 - Simple Calculation
I have no idea, since I cannot understand what you've done.
-- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Anthony1205" wrote in message ... So how does the formula work in all instances save where the result is zero? "Douglas J. Steele" wrote: As I already said, you cannot put formulae into text boxes. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Anthony1205" wrote in message ... I am sorry if I used the wrong terminology, but my initial post is the correct position, namely, "My form has three fields that I use for calculation: There is the [Fee] field representing what is charged, [Amount] field representing what is paid, and the [Balance] field which represents what is owing and is the field used for the actual calculation." The formula has been entered directly into the box under the label in form design view. Hope that clarifies things. Sorry for the confusion. Anthony |
#13
|
|||
|
|||
Access 97 - Simple Calculation
I have done nothing other than enter the formula, with which you assisted me,
into the field for [Balance]. The field (and formula) deals with all values save for negative or zero balances. However, it is only the zero value that throws up the pop-up alert that I mentioned. "Douglas J. Steele" wrote: I have no idea, since I cannot understand what you've done. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Anthony1205" wrote in message ... So how does the formula work in all instances save where the result is zero? "Douglas J. Steele" wrote: As I already said, you cannot put formulae into text boxes. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Anthony1205" wrote in message ... I am sorry if I used the wrong terminology, but my initial post is the correct position, namely, "My form has three fields that I use for calculation: There is the [Fee] field representing what is charged, [Amount] field representing what is paid, and the [Balance] field which represents what is owing and is the field used for the actual calculation." The formula has been entered directly into the box under the label in form design view. Hope that clarifies things. Sorry for the confusion. Anthony |
|
Thread Tools | |
Display Modes | |
|
|