Friday
Registered User.
- Local time
- Today, 18:27
- Joined
- Apr 11, 2003
- Messages
- 542
Folks, I'm not even sure how to ask this correctly. I have an inherited db that I have screamed each year for three years. Vehicle mileage db. Original author used wizards and macros to design and operate this db, and I have finally gotten around to re-designing it. Scrapped the old design completely. I know have two tables:
tblVehicles:
tblMileage:
tblVehicles.fldUnit linked to tblMileage.fldUnit
Figuring mileage each month is simple, except for December, which is the odometer reading for December subtracted from the odometer reading for January of the following year. This is the part I cannot get my brain around. Obviously that figure is not gathered until January is over. What I cannot seem to pin down is how to gather all this data into one report, mainly because of the December calculation. Any ideas on this?
tblVehicles:
ID
fldUnit
tblMileage:
fldUnit
fldYear (YYYY)
fldMonth (MM)
fldOdometer
tblVehicles.fldUnit linked to tblMileage.fldUnit
Figuring mileage each month is simple, except for December, which is the odometer reading for December subtracted from the odometer reading for January of the following year. This is the part I cannot get my brain around. Obviously that figure is not gathered until January is over. What I cannot seem to pin down is how to gather all this data into one report, mainly because of the December calculation. Any ideas on this?