simple math sql - need help
simple math sql - need help
(OP)
Am humble...need help w/ basic sql since I don't write it often enough
Sequence Rev SumPast4
1 100 n/a
2 110 n/a
3 105 n/a
4 103 418
5 55 373
6 90 353
etc etc
Table has first 2 columns...need the SumPast4 column created in query showing these three columns... don't need to worry about the n/a example just trying to show that the sum is of the current and past three records...
thanks in advance
Sequence Rev SumPast4
1 100 n/a
2 110 n/a
3 105 n/a
4 103 418
5 55 373
6 90 353
etc etc
Table has first 2 columns...need the SumPast4 column created in query showing these three columns... don't need to worry about the n/a example just trying to show that the sum is of the current and past three records...
thanks in advance
RE: simple math sql - need help
break on report;
compute sum of SumPast4 on report;
select "sequence rev", SumPast4
from "table name"
order by "sequence rev"
/
This should do it for you.
Thanks,
G. Feric, PE
http://engware.i-dentity.com