J
Jimmy_D
Hows it going!
We've just upsized our MS Access database to MSDE and are using an Access
Projects ADP front end.
Im trying to convert all our old reports to run on this new Access PRojects
front end
and I'm running into problems.
In my Access Projects Report, I cannot use any aggregate functions, sum, avg
in the control source of textboxes unless the control source
is a field from the stored procedure linked to the form, I was able to use
these functions on any textbox in regular Access, but now
I get Error messages like "Column ???? does not exist in appropriate rowset"
or "Aggregate Functions are only allowed on on output fields of the
recordsource"
In the detail section of my report, in a text box called txtTime I have the
control source set as "=([QtyProduced]/[TimePerProduct])*60"
QtyProduced and TimePerProduct are both fields from a stored procedure, and
theres no problem displaying these. When the report is activated it displays
the correct calculation in the txtTime text box
In the report footer section of my report, in a text box called txtTotalTime
on the bottom of the form I want to Sum up all values of all the txtTime
boxes from the detail section.
Setting the control source as "=Sum([Time])" or
"=Sum(([QtyPassed]/[CycleTime])*60)" brings up the errors listed above
So how do I use Sum or Avg on values of text boxes in an Access Projects
report?
Anyways any help would be appreciated!
Cheers!
We've just upsized our MS Access database to MSDE and are using an Access
Projects ADP front end.
Im trying to convert all our old reports to run on this new Access PRojects
front end
and I'm running into problems.
In my Access Projects Report, I cannot use any aggregate functions, sum, avg
in the control source of textboxes unless the control source
is a field from the stored procedure linked to the form, I was able to use
these functions on any textbox in regular Access, but now
I get Error messages like "Column ???? does not exist in appropriate rowset"
or "Aggregate Functions are only allowed on on output fields of the
recordsource"
In the detail section of my report, in a text box called txtTime I have the
control source set as "=([QtyProduced]/[TimePerProduct])*60"
QtyProduced and TimePerProduct are both fields from a stored procedure, and
theres no problem displaying these. When the report is activated it displays
the correct calculation in the txtTime text box
In the report footer section of my report, in a text box called txtTotalTime
on the bottom of the form I want to Sum up all values of all the txtTime
boxes from the detail section.
Setting the control source as "=Sum([Time])" or
"=Sum(([QtyPassed]/[CycleTime])*60)" brings up the errors listed above
So how do I use Sum or Avg on values of text boxes in an Access Projects
report?
Anyways any help would be appreciated!
Cheers!