Hi
i am trying to update the "cost" column in a table, just after adding a new
entry/record to the database.Confused abt where to put the UPDATE Table
statement.
Add statement is working fine... bt dont know how and where to write the
below sql query.
UPDATE user_input LEFT JOIN Stationery ON user_input.[item] =
Stationery.items
SET user_input.cost = [Stationery]![cost]*[user_input]![unit]
WHERE (((user_input.cost) Is Null));
Please suggest.
Thanks
--
**.··-.¸.-··. (`'·.¸(`'·.¸*¸.·'´)¸.·'´) .··-.¸.-··. **
With Love & Regards
Swapnil **`·´(¸.·'´(¸.·'´*`'·.¸)`'·.¸)`·´**
--~--~---------~--~----~------------~-------~--~----~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/excel-macros?hl=en
Visit & Join Our Orkut Community at
http://www.orkut.com/Community.aspx?cmm=22913620
To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com
To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
If you find any spam message in the group, please send an email to Ayush @
jainayus...@gmail.com
-~----------~----~----~----~------~----~------~--~---
