Tracking Dates

[Harold via AccessMonster.com]

Hi, I having a problem tring to keep track of dates and deciding what
information I need in order to track those dates. I need to track annual
building inspections. The first 2 years in the cycle a form is sent out so
the business owner can do their own inspections. On the 3rd year an
inspection is conducted by a building inspector. I need to track when and
what type of inspection is needed on each year. Also if on the first two
years the form is never sent back, then a inspector is sent out to do the
inspection. After an inspection by an inspector, no matter when it occured,
the cycle would start over again.

The idea would be to input the information on a form, and be able to pull the
re-inspections dates up on a report. Also, I would like to have a report to
let me know when an inspection form should be sent out or when on site
inspections had to be done in any perticullar week for any building. I cant
just add 365 days to the last inspection date because that would not account
for where they were in the cycle, or if it was a year where they were sent a
form or an inspector should go out. I guess I cant figure out how to keep
track of the form years and the inspection years and how to know what one it
is for a building.

Im not sure what information I should track or how to calculate the dates,
and how to keep track of the cycle and where each business is within the
cycle.

Thank you for any help you can give.

Harold

 

[Steve Schapel]

Harold,

It seems to me that if you have a Buildings table, and then an
InspectionsLog table, with fields something like this...
LogID
BuildingID
InspectionDate
InspectionType
etc
.... where InspectionType is for form/inspector, then this should provide
all the information you need to do your tracking and reporting. You
could use queries to identify the inspection type for last year and the
year before, and on the basis of that, you can derive whether this
year's needs to be form or inspector. You can also easily find
inspections due in any specified date range.

 

[Harold via AccessMonster.com]

I didnt have an inspections table, but I guess that would help.
I'll try it.
Thanks

Harold

Harold,

It seems to me that if you have a Buildings table, and then an
InspectionsLog table, with fields something like this...
LogID
BuildingID
InspectionDate
InspectionType
etc
... where InspectionType is for form/inspector, then this should provide
all the information you need to do your tracking and reporting. You
could use queries to identify the inspection type for last year and the
year before, and on the basis of that, you can derive whether this
year's needs to be form or inspector. You can also easily find
inspections due in any specified date range.

Hi, I having a problem tring to keep track of dates and deciding what
information I need in order to track those dates. I need to track annual

[quoted text clipped - 23 lines]

Harold