Thank you Rabbit for your response, it seems that the "Where" criteria was ambiguos or something.
Change it and it work!
serge castle
Last Activity: Oct 5 '11, 01:54 PM
Joined: Jul 19 '11
Location:
-
NeoPa, you were right.
I changed the criteria and it worked like a charm.
Thank you, very much!Leave a comment:
-
Rabbit, I'm not sure what do you mean by "manually run it". I use the DoCmd.RunSQL but I get this message "You are about to update 0 rows".
I also run it by hiting F8 key, with the same result:No error message, but not updating the table....Leave a comment:
-
Code:UPDATE 12MonthsTemp SET [Total Recognition]= -134255.64 WHERE ([Begin Date]=#5/1/2007#) AND ([End Date]=#4/30/2008#) AND ([Invoice Amount]=-11187.97);
Leave a comment:
-
Thank you for your response, but it still doesn't update the Total Recognition field...maybe I need another approach?Leave a comment:
-
Update statement doesn't update
Hello,
I'm kind of newby in VBA/SQL in access.
I'm trying to write a code that sums several columns and the result should be "updated" to a Total record.
I get no error message, but it doesn't work.
What can be wrong?
Here's part of the code.
...Code:sqlselect = "SELECT * From 12MonthsTemp" Set objrs = conn.Execute(sqlselect)
No activity results to display
Leave a comment: