I have created a Database to keep track of Mileage per day for two vehicles. I want to get total mileage by week, what do i need to do? Do i create a query or create a field in the table to calculate the total miles for that vehicle.
Novice
Windows 7 32bit 
Access 2010 32bit
I have created a Database to keep track of Mileage per day for two vehicles. I want to get total mileage by week, what do i need to do? Do i create a query or create a field in the table to calculate the total miles for that vehicle.
Competent Performer
Windows 7 64bit Access 2010 64bit
Query is best for calculated field.
Create a query that used group by and sum the milage for the vehicles.
Posting Permissions
Reply With Quote