Guest_imported
New member
- Jan 1, 1970
- 0
In the database that I have developed, I have a Form and a subform. The subform keeps track of specific delays incurred during a manufacturing process. The subform consists of the following fields, which are formatted as follows:
DelStart - Short Time
DelFinish - Short Time
Dur - Number (Which is the difference between DelFinish and DelStart)
DelCode - Text (Drop down list of all Delay Codes associated with the process)
Note - Memo field in which the user inputs any comments regarding delays of
an usual or excessive duration.
The Main form and the subform are linked on a one-to-many basis by use of the 'Auto-number' Primary key.
I then inserted a field in the subform footer which calculates the total delay for that particular process and this, in turn, is used to display the total delay on the Main Form.
Everything about this database runs just fine and my boss was very happy with its use.
That is, up until the time he asked if I could also display the total duration of a particular DelCode on the Main Form. I've been beating my head against a stone wall on this one and any assistance or direction provided to lead me to a solution will be greatly appreciated.
Thank you in advance.
DelStart - Short Time
DelFinish - Short Time
Dur - Number (Which is the difference between DelFinish and DelStart)
DelCode - Text (Drop down list of all Delay Codes associated with the process)
Note - Memo field in which the user inputs any comments regarding delays of
an usual or excessive duration.
The Main form and the subform are linked on a one-to-many basis by use of the 'Auto-number' Primary key.
I then inserted a field in the subform footer which calculates the total delay for that particular process and this, in turn, is used to display the total delay on the Main Form.
Everything about this database runs just fine and my boss was very happy with its use.
That is, up until the time he asked if I could also display the total duration of a particular DelCode on the Main Form. I've been beating my head against a stone wall on this one and any assistance or direction provided to lead me to a solution will be greatly appreciated.
Thank you in advance.