sdhanpaul (10/22/2012)

---

I read that article about 100 times.

I read about 100 articles comparing different types of running sum...of which:

clr is the best way to do it but i cant get pass cursor so how am i going to do clr?

nested subqueries are too slow...and way too slow too, i have this in ms access

update query thing...i tried but for some reason I dont seem to get it....

requested data:

table: RawTrx

Columns:

RawTrxIdintUnchecked

EmpNamechar(50)Checked

EmpPinnumeric(18, 0)Checked

trxDatedatetimeChecked

trxTimedatetimeChecked

forkeychar(50)Checked

fordeletebitChecked

forcountnumeric(1, 0)Checked

checked is allow null...

rawtrxid is primary key auto number.

I tried putting a where clause but gets a syntax error each time and every place i put it.