Ok, i need to make an access (ewww) database for my dad who is going to start being a taxi driver. He was trying to do something in excel, but i think it needs access really, and my access is weak.
Basically for each day there can be any number of entries, which are of type Fares (money made, tip, mileage), Empty Miles (mileage), or Fuel (litres, cost)
Now it seems fairly easy for me to link those to a day (have a unique id for each day, and they all have it too),
but each day has to link to a month (and not all months are the same or even fixed lengths, and have to be unique to the year). Can i do that the same way or is there something easier i'm missing ?
Again, those months need to link to a year, so that funky things like viewing last 6 months totals, etc can be done.
Is there a really easy way of doing all this lot, and i just can't think of it ?
edit : this is my proposed table structure so far.
Table dayitems
--------------
DayID (link to the day it belongs to)
Fuel Cost
Fuel Litres
Empty Miles
Fare Miles
Fare
Tip
Table days
----------
DayID (used to link items to each day)
MonthID (so we know which month we belong to)
Daynum (Purely for user display)
Monthnum (Purely for user display)
Yearnum (Purely for user display)
Table months
------------
YearID (to which year we belong)
MonthID (so days can link to us)
Monthnum (Purely for user display)
Yearnum (Purely for user display)
Table years
-----------
YearID (so months link to us)
Yearnum (Purely for user display)
Suggestions/comments appreciated
Threaded Mode