mysql = "UPDATE table1 SET TLs=DCount(*,""shipper='"" & shipper & ""' and filename='"" & filename & ""'"")"
*this is supposed to count occurances of duplicate field shipper & filename in table1 table.
I get
run-time error '3075':
Syntax error (missing operator) in query expression
'DCount(*,"shipper='"&shipper & " and filename='"& filename & "".
I couldn't see the code in message box to well but the line above should be more or less accurate.