Returns The Previous Record's Value In Another Field In A Query

S

Steve

Does any anyone have a procedure for a query where a calculated field returns
the previous record's value in another field. For example:

A
F A
Z F
M Z

The primary key is in random order in the query and the letters ar not sorted.

Thanks,

Steve
 
D

Duane Hookom

There is no "previous" record in Access. Consider all records as random
ordered unless you have a value to order them by.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Unique values in two fields in query 1
writing a value to a particular cell from function 3
VBA code returns no records hwenKey ID is added 14
Random Function for Selecting Records 6
select random records problem 7
Query filtering by Aggregate 3
Order of evaluation of functions in records & somewhat recursivefunction 4

Top