Hi,
I am trying to use DLOOKUP to pull a value from a table with decimal places. This code works but the decimal places are dropped, and VarType() shows that it is pulling that value as a Long Integer (type 3). How can I force it to keep the decimal places?
Code:tempMat = Me.MaterialName.Value ' this is selected from a drop down decimalValue = DLookup("[HALF_LIFE_HOURS]", "MATERIAL_TABLE", "MATERIAL_DESCRIPTION = '" & tempMat & "'") MsgBox (VarType(decimalValue))