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.
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.
Query is best for calculated field.
Create a query that used group by and sum the milage for the vehicles.