How can I get a Record of a Query to refer to a value in the previous record? Thanks GA
G Graham May 3, 2004 #1 How can I get a Record of a Query to refer to a value in the previous record? Thanks GA
L Lynn Trapp May 3, 2004 #2 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.
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.
L Lynn Trapp May 4, 2004 #4 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?
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?
