MicroSoft Access

[janpan]

Is there a way to calc a prev record. Just say I want 2% of the prev total

 

[EPT]

Not exactly sure what you're doing but why not simply add another field to you query or form where newtotal=[prevtotal] * .02

 

[Dale3]

Depends on whether you mean in Access or by using VB. I have never found a way in Access by itself to query a record and apply its values to a different record. But if you go into VB, then you can open a recordset and store the value for a record into a variable, do the math you want, then save the result in a subsequent record of your selection.

I remember trying to do this when I was just starting with Access and it was very frustrating not to be able to find a way.

 

[lbpsfl]

You could use a scratch table with an autonumber field. Clear the table, Append new data (not make table,) do a self-join.

OR:
Many years ago I saw a SQL statement (Sybase) that produced
1
2
3...

I don't recall the syntax, but you might find it on a SQL site or board.