commas

[peljo via AccessMonster.com]

I am again having problems with these damned commas, they seem never to
conform to my knowledge.I tried to convert the otherwise good and working
update query into an sql but i got red colours showing that Access does not
accept my commas.I tried with single commas ' or with double commas """" but
obviously i jumbled the commas up with no result.Would you help me convert
the update query below into an sql ?


UPDATE products SET products.items5 = DLookUp("Diff","qryNetDiff",
"ProductID=" & [ProductID])
WHERE (((products.Productid) In (SELECT ProductID FROM qryNetDiff)));

 

[Jeanette Cunningham]

Hi again Peljo,

strSQL = "UPDATE products SET products.items5 = " _
& "DLookUp(""Diff"",""qryNetDiff"", ""ProductID="" & [ProductID]) " _
& "WHERE products.Productid " _
& "In (SELECT ProductID FROM qryNetDiff)"


Jeanette Cunningham

 

[Steve Sanford]

I think that the DLOOKUP() function should be outside of the quotes. Add
another line after "strSQL=..." to check (and delete or comment it after
testing):

Msgbox strSQL



I would have used:

strSQL = "UPDATE products SET products.items5 = " _
& DLookUp("Diff","qryNetDiff", "ProductID=" & [ProductID]) _
& " WHERE products.Productid " _
& "In (SELECT ProductID FROM qryNetDiff)"

Msgbox strSQL


Also, if "products.items5" is a string, don't forget to delimit the
DLOOKUP() function with single quotes.

strSQL = "UPDATE products SET products.items5 = '" _
& DLookUp("Diff","qryNetDiff", "ProductID=" & [ProductID]) _
& "' WHERE products.Productid " _
& "In (SELECT ProductID FROM qryNetDiff)"

Msgbox strSQL


Happy Holidays


HTH
--
Steve S
--------------------------------
"Veni, Vidi, Velcro"
(I came; I saw; I stuck around.)

Hi again Peljo,

strSQL = "UPDATE products SET products.items5 = " _
& "DLookUp(""Diff"",""qryNetDiff"", ""ProductID="" & [ProductID]) " _
& "WHERE products.Productid " _
& "In (SELECT ProductID FROM qryNetDiff)"


Jeanette Cunningham

I am again having problems with these damned commas, they seem never to
conform to my knowledge.I tried to convert the otherwise good and working
update query into an sql but i got red colours showing that Access does
not
accept my commas.I tried with single commas ' or with double commas """"
but
obviously i jumbled the commas up with no result.Would you help me convert
the update query below into an sql ?


UPDATE products SET products.items5 = DLookUp("Diff","qryNetDiff",
"ProductID=" & [ProductID])
WHERE (((products.Productid) In (SELECT ProductID FROM qryNetDiff)));