Default Date Range

[Steve]

I have just started building a database and have received some great advice
here. I've got several tables for our transitional housing program built.
Most of the information is date sensitive. I have a tblPerson with
relationships to tblApplication, tblLease, tblIncome,etc. The reports I'm
required to compile by different funding sources track income and other
things for each person over time. Usually the length of the tenancy. A
person can have several tenancy (lease) records over a period of time. I
already have been told that I need to use a StartDate and EndDate for much
of the information so that I can track it for a lease period. Because most
of my information is date sensitive I have many tables with StartDate and
EndDate. My question is: Isn't this redundant a lot of the time? Lot's of
people only enter our program once so they have an EntryDate and an
ExitDate. The StartDate and EndDate for their sources and amounts of income
would be the same. Is there a way to automatically enter their EntryDate
and ExitDate into the related tables StartDate and EndDate fields with the
option to override it? In other words. I don't want to have to have a
dozen intake forms each requiring a person to enter StartDate and EndDate.

Hope this makes sense.
TIA
Steve

 

[Duncan Bachen]

I have just started building a database and have received some great advice
here. I've got several tables for our transitional housing program built.
Most of the information is date sensitive. I have a tblPerson with
relationships to tblApplication, tblLease, tblIncome,etc. The reports I'm
required to compile by different funding sources track income and other
things for each person over time. Usually the length of the tenancy. A
person can have several tenancy (lease) records over a period of time. I
already have been told that I need to use a StartDate and EndDate for much
of the information so that I can track it for a lease period. Because most
of my information is date sensitive I have many tables with StartDate and
EndDate. My question is: Isn't this redundant a lot of the time? Lot's of
people only enter our program once so they have an EntryDate and an
ExitDate. The StartDate and EndDate for their sources and amounts of income
would be the same. Is there a way to automatically enter their EntryDate
and ExitDate into the related tables StartDate and EndDate fields with the
option to override it? In other words. I don't want to have to have a
dozen intake forms each requiring a person to enter StartDate and EndDate.

Hope this makes sense.
TIA
Steve

Sure, you can ask for the information one time, and store the chosen
values in a table (possible with tblPerson). Then, in any of your
queries that have a date range requirement, you can DLookup() the
value of the start and end dates and use them as your criteria for
limiting the values.


-D