MS Access database support - How to create query with calc'd field that equals value of [Field] in previous record + value of [A

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

How to create query with calc'd field that equals value of [Field] in previous record + value of [A

MLH

2006-04-07, 1:31 pm

Fields in MyTable:

PostID
PostDate
RollQtyXfer
RollDenomination
RollCount37
RollCount23

PostID is an A97 AutoNumber field. PostDate is a Date field.
The rest of the fields are Integer type.

This is what I want to see in a query:
[PostID] [PostDate] [RollQtyXfer] [RollCount37] [CalcValue]
where [PostID]>1 and CalcValue is a calculated field that
equals [RollCount37] in the PREVIOUS record + [RollQtyXfer]
value in the current record.

Is it possible?

Sponsored Links