C
Chris B via AccessMonster.com
Please help,
I have a database in to which start date/time and end date/time is entered,
from this I have calculated fields which calculate the timeDiff, also another
which calculates the time from a Midnight reference.
A rate is entered and this calculates the amount of money due.
This is all working perfectly, the problem is when I try to sum the
calculated fields, I keep getting #ERRORs,
I have tried to place the Sum() in both form footer as well as the report
footer, I too have tried by placing the complete expression into the Sum
(expression).
Where else can I put the Sum(), I dont mind if its only ever displayed once
the report is generated.
I have read other threads and have tried by changing the Running sum property
of my Sum text box to Over group and tried Over All, still no avail.
Any suggestions would be much appreciated!
I have a database in to which start date/time and end date/time is entered,
from this I have calculated fields which calculate the timeDiff, also another
which calculates the time from a Midnight reference.
A rate is entered and this calculates the amount of money due.
This is all working perfectly, the problem is when I try to sum the
calculated fields, I keep getting #ERRORs,
I have tried to place the Sum() in both form footer as well as the report
footer, I too have tried by placing the complete expression into the Sum
(expression).
Where else can I put the Sum(), I dont mind if its only ever displayed once
the report is generated.
I have read other threads and have tried by changing the Running sum property
of my Sum text box to Over group and tried Over All, still no avail.
Any suggestions would be much appreciated!