Update query with currency

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

Guest

I have a simple update query that sets 2 fields in the target table equal to
the corresponding fields in the from table. The tables are joined on one
field (CustomerNo). Problem is that the query rounds down the values to
whole numbers (dollars). The field formats in the query, the target table
and the from table are set to currency.

Any suggestions

Thanks
 
Ultimately the value gets stored in a field in a table.
Open this table in design view.
Change the Data Type for this field to Currency.

I'm guessing the field type is Number, and the Field Size (lower pane of
table design) is Long Integer. The integer types cannot hold fractions.
 
Found the problem. The target table was being created by a make table query
upstream from the update query. It was resetting the format of the fields in
the target table to long Integer each time I ran the Event Procedure.

Thanks





Frank C
 
Back
Top