Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2006
    Location
    Tucson, Arizona
    Posts
    19

    Question Unanswered: How to populate one field by multiplying two others?

    I have two fields in an Access form that I'd like to automatically multiply together to fill in a third field. The three field values are: 1) Job Amount (currency), 2) Percent Complete, and 3) Work in Progress. One minus (the Job Amount times the Percent Complete) equals the Work in Progress. I probably need a string of code that will multiply the two values together and populate the Work in Progress field. Any suggestions would be greatly appreciated. Thanks!

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    You shouldn't store a value that can be calculated from others, especially one that will keep changing. Simply multiply them in queries, forms or reports as needed.
    Paul

  3. #3
    Join Date
    Apr 2006
    Posts
    157
    yup, you normally just want to store the root values, and do your calculations on display...

    but then, it's not such a bad idea, so that when i display it on continuous forms, i won't have to reprocess calculations...

    why am i saying this? i've had to use some domain functions on continuous form view and it's slowing down my db so bad, it looks ugly
    Only quitters quit!

  4. #4
    Join Date
    Jul 2006
    Location
    Tucson, Arizona
    Posts
    19
    I went ahead and calculated the Work in Progress value in a report. It works fine. Thanks!

Posting Permissions

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