Retrieving a value from previous record

  • Thread starter Lawrence Kritzinger
  • Start date
L

Lawrence Kritzinger

Hi all,

sorry, I'm not sure if I'm at the right place, I'm completely new to MS
Access and need some help:

I have created a query based on the table containing my data (vehicle fuel
transaction). I need to calculate the difference between the odo field for
this record and the previous record and display it in a field.

Please could you point me in the right direction?

Regards

Lawrence
 
R

Rebecca Riordan

Lawrence,

First you need to define what you mean by "previous" record. Records in a
table don't really have an order. They're displayed like a spreadsheet, but
that's misleading, the reality is closer to a bunch of snippets in a brown
paper bag. So, how can you specify the record you want compare? And where
do you want this to happen, in a form or a query?

--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...
 
Top