vehicle fuel consuption access database

[Daniel2000]

have designed a small access database to monitor fuel consuption. each time we issue a fuel voucher, we record vehicle number plus mileage (meter reading) at start and end and database automatically calculates no of km.

as of now, users have to enter the meter reading at start and meter reading at end manually using a form.

what i want is when i choose the car number from my form, then meter reading at start should capture the last meter reading at end (prior to today's entry date) as the default meter reading at start. this will be a locked properties and users will not have input access.

[JoeM]

Perhaps you can use an Aggregate (Totals) query to return the latest record.

[drunkenneo]

By looking to your problem it seems there is a record combination of vehicle number and meter reading, from there you need to extract the data by using function from taking top reading from order by date.

However if the database is shown then i would be able to help all the problems you have.

[Daniel2000]

hi drunkenneo.

Database attached.

Database1.zip