Dear Extinguisher- (name?)
You shouldn't store that sort of calculated data in your table. If you want to
see the next service date, use an expression in a query on the table. Please
post an example of the data in the "next service interval" field.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of
the_extinguisher_pro
Sent: Sunday, May 29, 2011 12:19 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] How to make a database for my business
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?
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar