Previous Row of Data

Thanks for taking the time to read my question.

Just wondering if it is possible to make a formula in a query that refers to
the previous row of data while still working in the current row of data.

Thanks,

Brad

Define what you meant by "previous".

Records are stored unordered in JET. When you retrieve Records, Access will
use some sort of default ordering, usually the PrimaryKey. However, you
cannot rely on this 100%.

Since "previous" implies ordering in some way, you need to spell out the
ordering / sorting you want and include this in your Query.

Post relevant Table Structure, the ordring required and what you need from
the "previous" Record in the current process.

--
HTH
Van T. Dinh
MVP (Access)





"Brad" wrote in message
...
Thanks for taking the time to read my question.

Just wondering if it is possible to make a formula in a query that refers
to
the previous row of data while still working in the current row of data.

Thanks,

Brad

Thanks so much for the quick reply.

I have been trying to help a user here, and suggested a few things to avoid
this. They said they tried my suggestions, but they didn't work. I tried
them and now they work.

The user said he did this once before, and said there was some sort of
Access function that allowed him to do this. He forgets what it is called.

I have now solved the problem, but am still curious if this function really
exists.

Thanks again,

Brad

"Van T. Dinh" wrote:

Define what you meant by "previous".

Records are stored unordered in JET. When you retrieve Records, Access will
use some sort of default ordering, usually the PrimaryKey. However, you
cannot rely on this 100%.

Since "previous" implies ordering in some way, you need to spell out the
ordering / sorting you want and include this in your Query.

Post relevant Table Structure, the ordring required and what you need from
the "previous" Record in the current process.

--
HTH
Van T. Dinh
MVP (Access)





"Brad" wrote in message
...
Thanks for taking the time to read my question.

Just wondering if it is possible to make a formula in a query that refers
to
the previous row of data while still working in the current row of data.

Thanks,

Brad