David Ball
Registered User.
- Local time
- Tomorrow, 04:54
- Joined
- Aug 9, 2010
- Messages
- 230
Hi,
I have attached a database. There is a form displayed when the database is opened. If you select a date (say 21-Jul-2017) you will see that the Subtotal for Project for JC + DC Hours (Text53) is not summing the values for each Project correctly.
For each Project the Disciplines are displayed with the number of SI Hours, JC Hours and DC Hours. I have a calculated field that adds JC Hours to DC Hours and shows the sum for each Discipline (if there are both JC Hours and DC Hours). This is textbox Text33.
This works well but I want to also show a total of the JC + DC Hours for each project, and this is the part I can’t get to work.
Please note that I can’t just add the JC hours in the Subtotal for Project section to the DC Hours in this section as this gives an incorrect total in many cases (where some Disciplines have only JC Hours or DC Hours, but not both).
What formula do I need to put into Text53 to show the correct result?
Thanks very much
Dave
I have attached a database. There is a form displayed when the database is opened. If you select a date (say 21-Jul-2017) you will see that the Subtotal for Project for JC + DC Hours (Text53) is not summing the values for each Project correctly.
For each Project the Disciplines are displayed with the number of SI Hours, JC Hours and DC Hours. I have a calculated field that adds JC Hours to DC Hours and shows the sum for each Discipline (if there are both JC Hours and DC Hours). This is textbox Text33.
This works well but I want to also show a total of the JC + DC Hours for each project, and this is the part I can’t get to work.
Please note that I can’t just add the JC hours in the Subtotal for Project section to the DC Hours in this section as this gives an incorrect total in many cases (where some Disciplines have only JC Hours or DC Hours, but not both).
What formula do I need to put into Text53 to show the correct result?
Thanks very much
Dave