Update Querry type conversion error

[Leonard Hart]

I have two querrys to update a master table from two
detail tables (One is orders and one is payments). I want
to update in the master table the order total and the
payment amount totals. All fields are formatted
currency. The orders update querry works fine. The
payments update gives an error message of type conversion
error and will not work. Both are designed the same. Any
suggestions very welcome.

 

[[MVP] S. Clark]

Format only changes the way the data is displayed. Inspect the data types
of all fields involved in the update.

You may need to use one of the data type conversion functions to complete
the operation.

i.e. cint, clng, cdbl, etc.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-