I have Access 2007 and i'm fairly new at it. I have a business of fire extinguisher service. The service is usualy done once a year. i already have all my table made in access, but encountered a problem... I have a "tblClients" with a related "tblInventory" which has all info about each extinguisher the customer has. Then there is a "tblService" related to "tblInventory" to keep track of each service done to each extinguisher. That table "tblService" has a field for the "Now() Date" representing the date the service was done, another field for the type of service that was made and a third field for the interval for the next service (monthly, every 6 months, or annualy)... and I need to add another field to indicate the date of the next service based on the las service date and the interval. Who do I make this happen?
Tidak ada komentar:
Posting Komentar