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!