I have a question.
I have a query contains two columns one home one away.
evertime i insert a goal in the table it gives 1 or 0
home away
1 0
0 1
1 0
now i need this
home away
1 0
1 1
2 1
every next record looks to previous record and count it
does someone know how to do this.
ThanXs
I have a query contains two columns one home one away.
evertime i insert a goal in the table it gives 1 or 0
home away
1 0
0 1
1 0
now i need this
home away
1 0
1 1
2 1
every next record looks to previous record and count it
does someone know how to do this.
ThanXs