Insert Formula in control textbox in Access 97

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Henderson44
    New Member
    • Mar 2010
    • 2

    Insert Formula in control textbox in Access 97

    How do I enter a formula/expression in a textbox control that will calculate 2 two fields. Example: =[Units Sampled] - [Units Passed] the total should appear in the field (Units Failed)?
  • missinglinq
    Recognized Expert Specialist
    • Nov 2006
    • 3533

    #2
    Place exactly what you have

    =[Units Sampled] - [Units Passed]

    in the textbox Control Source in the Properties Pane..

    Welcome to Bytes!

    Linq ;0)>

    Comment

    • Henderson44
      New Member
      • Mar 2010
      • 2

      #3
      Error Message from Formula entered in Textbox Control

      I have entered the formula in the textbox control that should have the end result.
      example: =[Units Sampled] - [Units Passed]
      The error message on the form appears as this (#Name?) what should I do?

      Comment

      Working...