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
best is not to save the Computation in a Field (Workorder Line Item Amount), but just calculate it in a Query and use the Query as the RowSource of your form.
select field1, field2,
IIF(Nz([Workorder Line Item Quantity], 0) > 0, [Workorder Line Item Quantity], 1) * [workorder line item amount base] AS [Workorder Line Item Amount] FROM yourTableName
select field1, field2,
IIF(Nz([Workorder Line Item Quantity], 0) > 0, [Workorder Line Item Quantity], 1) * [workorder line item amount base] AS [Workorder Line Item Amount] FROM yourTableName