T
Tojib
I have a database in XP Access 2002 in which data is entered regarding
programs running at various regional locations. Included are program start
and stop dates, with the stop dates adjusted automatically by location if
there are delays in bringing the location online. The main program data entry
form contains all of the date information fields and there is a subform to
enter the related locations. Location live dates come from a location
information table.
What I am struggling with is how I might be able to have my reports extend
certain programs at one or two locations and have just those stop dates at
those locations affected, leaving everything else as is. Obviously, if I use
the program entry form, all locations on the subform will be changed.
I am considering the addition of a new section on the program data entry
form for extensions. It would have the number of days to extend and a
location subform for specific locations. The problem arises in my queries
when I try to have multiple location tables reporting on the regular schedule
(with adjustments) and the extension requirements. Perhaps I somehow need to
cascade queries, getting results from one and then add the new location table
to a new one.
Don't know if I've been clear enough. Thoughts would be very welcome. Thanks.
programs running at various regional locations. Included are program start
and stop dates, with the stop dates adjusted automatically by location if
there are delays in bringing the location online. The main program data entry
form contains all of the date information fields and there is a subform to
enter the related locations. Location live dates come from a location
information table.
What I am struggling with is how I might be able to have my reports extend
certain programs at one or two locations and have just those stop dates at
those locations affected, leaving everything else as is. Obviously, if I use
the program entry form, all locations on the subform will be changed.
I am considering the addition of a new section on the program data entry
form for extensions. It would have the number of days to extend and a
location subform for specific locations. The problem arises in my queries
when I try to have multiple location tables reporting on the regular schedule
(with adjustments) and the extension requirements. Perhaps I somehow need to
cascade queries, getting results from one and then add the new location table
to a new one.
Don't know if I've been clear enough. Thoughts would be very welcome. Thanks.