Field from append qry being added to table as 0

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have this expression to determine which commission rate to use in an append
qry.
FinalCommRate: IIf(Not
IsNull([dbo_ar_cstmrmst]![commission_plan]),([dbo_op_commplandt_1]![commission_rate]/100),([dbo_op_commplandt]![commission_rate]/100))
The resulting values appear in datasheet view, but when when I run the qry
the values are set to 0 in the target table. I've tried adjusting number
formats to match but with no luck. I've dumped the values into a text field
in the table, and the values appear correctly.
What might I be missing? Thanks! Dave Miller
 
The number format relates to how they are displayed. Have a look at the
field type to establish how they are stored (I am guessing it's set for
Integer / long)
 
Back
Top