Calculating a value from multiple records

[Waheed2008]

Hello,
I am stuck in a problem and need some help. I have a table having the following fields:
ID, VehicleName, Date, MeterReading
In a company I need to maintain records of vehicles so that after every alternate day, I need to put the odometer reading of every vehicle into database. Now I want to generate a report on weekly/monthly bases so that user give a week number or month name and report show the mileage or total distance traveled (after calculating MeterReading) in that time span.
How can I do that? Please help me out. Thanks in advance.
Abdul Whaeed

 

[Trevor G]

I would look at creating a query to show all of the data, then use the report wizard to create a new report as you can add groupings like vehicle registration, then you can show the start reading and end based on dates then you can add extra text fields to calculate the differences etc and posiibly have the calculation in the group headings or in the data area.