Is This Possible?

[Karen]

First, I don't know if this is possible and second, I don't know if it's
best to use Access or Excel. This is what I want to do:

I have many instruments that I have to calibrate annually and every 6
months. I would have 5 fields: Instrument Description, Instrument
Manufacturer, Serial No., Date Calibrated; Calibration Due Date. I want to
record all this information, but I want to be able to flag 4 different people
in the company (via Outlook) two weeks prior to the calibration due date. Is
this possible?

Thank you, Karen

 

[KARL DEWEY]

You need to add a field for key field as ID, add a field for calibration
interval and possibly information of calibration level.
You need to review you equipment list for a common interval method - days,
months, etc. Use the interval as a multiplier such as 180 days or 6 months.
Move calibration dates to another table. You need to maintain the records
on when it was calibrated for historical purposes - traceability.
CalTable --
ID - foreign key to match equipment ID field
CalDate - datetime - date of actual calibration
Remarks - text - note of any limitations - 500 volt scale 10 percent

Use a query to calculate the date due by using DateAdd function.
Calibration Due:
DateAdd("m",[YourEquipTable].[Interval],Max([CalTable].[CalDate]))

Criteria <=Date() + 14