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

  • Thread starter Thread starter Steve
  • Start date Start date
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
 
There is no "previous" record in Access. Consider all records as random
ordered unless you have a value to order them by.
 
You must log in or register to reply here.

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

Unique values in two fields in query 1
Scrabble Value calculation for Welsh words 0
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Searching for Records in a Report 1
Tweaking a calculated field in a query 4
Query which Value Returns Previous Record 8
Split data in field on character return 0
Access Query criteria based on other field of the same query 0

Back
Top