Looking for a mileage tracker that:
?
- Calulates personal, business and total mileage
- Uses an access database, visible? with a datagrid or something similiar the display Fields needed are
date
location
purpose (business or personal)
start mileage
end mileage
business and personal fields
- I would like the "start" location and purpose fields set as auto complete
- Once an entry is added to the database the end mileage is auto-entered in the start mileage field, the purpose and date field is maintained until a manual change when adding new entries.
I make entries all month long so it will need to maintain its current state.
I would like the database to be able to be coverted to an excel file when I am finished at the end of the month and the database able to be reset with everything except the very last entry from the month.? The excel file must use the same layout as the datagrid.
- On? another form stores my customer database in a separate database file where I can add, delete or edit also displayed in a datagrid or similiar.
I have an example that I have been working on and would like to keep the same layout if possible.? I am only a beginner and still learning any feedback would be great.
I am sure that I am forgeting something here that we can discuss or add once project is started.
I will attach the file if I can or send it via email once accepted.
Thanks