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 Friends
I 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 Commentary
123 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?