update DSUM error

[Guest]

Trying to update in one table, "Invoice", by totally a feild [Total$] in,
"Incoice Parts", where invoice numbers match in both tables

Useing: DSum("[Total$]","Invoice Parts","[Inv#] =" & [Invoice#])

and get not records updating. error message - "did not update due to type
conversion failure"

any thoughts?

 

[Guest]

Hi KLM,
If the [Invoice #] is defined as text filed, then you have to put them in
quotes (single or double). Like

DSum("[Total$]","Invoice Parts","[Inv#] ='" & [Invoice#] & "'")

Hope this will help.

 

[Brian]

Trying to update in one table, "Invoice", by totally a feild [Total$] in,
"Incoice Parts", where invoice numbers match in both tables

Useing: DSum("[Total$]","Invoice Parts","[Inv#] =" & [Invoice#])

and get not records updating. error message - "did not update due to type
conversion failure"

any thoughts?

Most likely Invoice# is a text field, in which case you'll need to do this:

DSum("[Total$]","Invoice Parts","[Inv#] =""" & [Invoice#] & """")