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 |
|
seyed
Starting Member
2 Posts |
 Posted - 2009-03-10 : 15:28:01
|
| I am trying to get sum of column on a table witch it is comparing to the Previous rec.I have added new column and using IIF to compare previous rec. and set the fields to one, but could not get the total on a new field.Also did created new field to calculate comparing two rec. but new field could not check Previos rec. and crashed the application.Anyone has any idea how to do this? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-03-10 : 15:30:38
|
| What did you try? |
 |
|
|
seyed
Starting Member
2 Posts |
Posted - 2009-03-10 : 15:35:54
|
| I did try using new column and did not have sum and also new field and could not read previous rec. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Running Total Fields