|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 3rd, 2004, 01:46 PM
|
|||
|
|||
Refering to Previous Record
How can I get a Record of a Query to refer to a value in
the previous record? Thanks GA 
|
|
#2
May 3rd, 2004, 06:43 PM
|
|||
|
|||
|
Refering to Previous Record
Well, that depends a great deal on what you mean by "previous". A database
does not store records in any particular order and, thus, what is the "previous" record at one moment may not be at the next. -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm "Graham" wrote in message ... How can I get a Record of a Query to refer to a value in the previous record? Thanks GA
|
|
#3
May 4th, 2004, 12:42 AM
|
|||
|
|||
|
Refering to Previous Record
The record with the last date before the current record.
|
|
#4
May 4th, 2004, 06:27 PM
|
|||
|
|||
|
Refering to Previous Record
Then that might be a workable situation. Can you describe the rest of the
data a bit and tell what fields you are trying to reference? -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm wrote in message ... The record with the last date before the current record.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
