DSUM decimal data type in a query.
Posted on 2012-08-23
I have been trying to sum values (quantity) from a related table and preserve or convert the data to decimal. The original field has the decimal data type but when the function retrieves and sums the data the data type is string. Here is the field definition:
QuantityShipped: Nz(DSum("Quantity","qryDeliveryItemWithOrderNumber","MfgItemNumber = '" & [MfgItemNumber] & "' AND OrderNumber = " & [OrderNumber]),0)
I have tried every method I can think of to preserve or convert the data back to decimal without success.