I'm guessing you want to show the difference between a reading and the previous one.
Here is a demo:
Here is a demo:
Table1 fields: ID (AutoNumber), Reading
Query1:
SELECT Table1.ID AS ID, Table1.Reading AS Reading, Table1_1.ID AS [Previous ID], Table1_1.Reading AS [Previous Reading], [Table1]![Reading]-[Table1_1]![Reading] AS Change
FROM Table1, Table1 AS Table1_1
WHERE (((Table1_1.ID)=[Table1]![ID]-1));
SELECT Table1.ID AS ID, Table1.Reading AS Reading, Table1_1.ID AS [Previous ID], Table1_1.Reading AS [Previous Reading], [Table1]![Reading]-[Table1_1]![Reading] AS Change
FROM Table1, Table1 AS Table1_1
WHERE (((Table1_1.ID)=[Table1]![ID]-1));
Dave W
__._,_.___
Posted by: "Dave W" <davewi11@yahoo.co.uk>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (6) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar