C
ColinADP
I have converted an Access database to and ADP. We had a report which showed
helpdesk calls and the time it took to complete each one and at the bottom of
the report and at the end of each group was a text box with the countrol
source as =sum([Time to Complete]). This worked OK in Access, however now
that it is an ADP, it does not work. I have tried to change the control
source and go a running sum over group, however this does not work either as
it says that you cannot do a sum function on a non-numeric field - the field
is datetime. Any ideas?
helpdesk calls and the time it took to complete each one and at the bottom of
the report and at the end of each group was a text box with the countrol
source as =sum([Time to Complete]). This worked OK in Access, however now
that it is an ADP, it does not work. I have tried to change the control
source and go a running sum over group, however this does not work either as
it says that you cannot do a sum function on a non-numeric field - the field
is datetime. Any ideas?