Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gopinath.m.v
Starting Member
1 Post |
 Posted - 2011-11-22 : 09:27:57
|
Hi FriendsI would be grateful if you give a solution for this problem:I am using a table in MS-Access and queries. I have a table in MS-ACCESS in which 3 columns : account_no, amount, commentary are there.I want to update commentary column if sum of those records are equal to 10 Million.Example :Account Amount Commentary123 1000000 456 2000000 789 3000000 1012 4000000 1234 5000000 Here I want to update commentary column as "GREATERTHAN 10M" if the sum of these selected records are greater than equal to 10 Million.I used update command which is not giving result.Its very urgent required for a project. I would be grateful if you give solution for this.
Gopinath |
|
|
|
|
|
Update Query with select and if..... How?