update DSUM error

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

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?
 
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.
 
KLM said:
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?
Click to expand...

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

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