Daily useage

[Guest]

Daily meter readings are entered into a table.
How can I obtain the daily useage or consumption either in a query or form?
Example: Meter reading as of 6/10/07 is 77,189. Meter reading as of
6/11/07 is 78,150. How can I see what was used from 6/10 to 6/11?

THANKS FOR ANY SUGGESTIONS!

 

[Guest]

Try this using your table and field names --
SELECT kaltman.Meter, kaltman_1.ReadDate,
Max([kaltman_1].[Reading]-[kaltman].[Reading]) AS [Daily Usage]
FROM kaltman INNER JOIN kaltman AS kaltman_1 ON kaltman.Meter =
kaltman_1.Meter
WHERE (((kaltman_1.ReadDate)>[kaltman].[ReadDate]))
GROUP BY kaltman.Meter, kaltman_1.ReadDate
ORDER BY kaltman_1.ReadDate;