Forum Discussion
computations not putting result in correct field..
three fields are on the sub form. It is accessing the data correctly from the source table, but the result is not stored in the correct field. Here is the computation: If Me
dmsitech am I guessing correctly that you have this code as the expression for a calculated field?
It is a calculated field on the form. The result is stored in a field on the db.
here is the code
If Me![Workorder Line Item Quantity] > 0 Then Me![Workorder Line Item Amount] = Me![Workorder Line Item Quantity] * Me![workorder line item amount base] Else Me![Workorder Line Item Amount] = Me![workorder line item amount base]
it is recognizing the "If" statement, but the result is stored in work order line amount base. the result should end up in workorder line item amount
- I believe i need someone to look at the actual form and underlying db
i did connect with MS Support who looked at the db and said there are no errors, so they pointed me to the forum.
How can i get hands on help?
