B
bernie
Hi out there!
I have one company, a main office and two subsidiaries. The subsidiaries are
working for them self.
Fields are: Date process started, Date process ends
Queries are to provide information on main office as well as the
subsidiaries: “Days between Start and End of Process†and “Days of not Ended
Process till Todayâ€.
Same information is required for each subsidiary individually also.
qryOverall_Information
qrySubsidiary_A
qrySubsidiary_B
The qryOverall_Information contains as “Criteria†in the Field “Date Process
started†the line â€Between [StartDate] And [EndDate]†After entering
StartDate and EndDate the query shows up with the Data in the given timeframe.
With the same Criteria in the qrySubsidiary_A and _B each individual Query
comes up with the required data also.
A form “frmUsed_and_Open Time†is created to show the Overall Information
(out of qryOverall_Information) and is working perfect, after entering the
StartDate and EndDate according to the appropriate msgBox.
However in this form two subforms are integrated containing information of
both queries qrySubsidiary_A and qrySubsidiary_B.
When opening the form now it is necessary to enter StartDate and EndDate 3
times in order to get the correct numbers.
When omitting the Criteria in both subsidiary queries, only once the
StarDate and EndDate has to be entered but the subsidiaries information is
the total numbers and not the one for the requested time frame.
How will I be able to enter the timeframe once only but get from all the
forms the correct numbers?
Do I think too simple and do I have to program “Event Procedures†like “on
Focus†etc.?
Thank you for any help.
Bernhard Edler von Lapp
I have one company, a main office and two subsidiaries. The subsidiaries are
working for them self.
Fields are: Date process started, Date process ends
Queries are to provide information on main office as well as the
subsidiaries: “Days between Start and End of Process†and “Days of not Ended
Process till Todayâ€.
Same information is required for each subsidiary individually also.
qryOverall_Information
qrySubsidiary_A
qrySubsidiary_B
The qryOverall_Information contains as “Criteria†in the Field “Date Process
started†the line â€Between [StartDate] And [EndDate]†After entering
StartDate and EndDate the query shows up with the Data in the given timeframe.
With the same Criteria in the qrySubsidiary_A and _B each individual Query
comes up with the required data also.
A form “frmUsed_and_Open Time†is created to show the Overall Information
(out of qryOverall_Information) and is working perfect, after entering the
StartDate and EndDate according to the appropriate msgBox.
However in this form two subforms are integrated containing information of
both queries qrySubsidiary_A and qrySubsidiary_B.
When opening the form now it is necessary to enter StartDate and EndDate 3
times in order to get the correct numbers.
When omitting the Criteria in both subsidiary queries, only once the
StarDate and EndDate has to be entered but the subsidiaries information is
the total numbers and not the one for the requested time frame.
How will I be able to enter the timeframe once only but get from all the
forms the correct numbers?
Do I think too simple and do I have to program “Event Procedures†like “on
Focus†etc.?
Thank you for any help.
Bernhard Edler von Lapp