Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Location
    Hertfordshire, England
    Posts
    78

    Question Unanswered: Compare Two Numbers and Return Difference

    Hi

    I need to compare the value of two controls on my form and return the difference between them. Both controls will contain a number in currency format with two decimal places. A third control with the same format settings will hold the difference between the other two controls.

    What is the best way to go about this? Is there a built in function in Access to do this?

    Thanks

    Neil.

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    You have got to be kidding me ...

    SomeControl.Value=CCur(Textbox1.Value)-CCur(Textbox2.Value)
    Back to Access ... ADO is not the way to go for speed ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •