Control Names not found

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

five texboxes on my report are causing problems. When I run the report I am
prompted for parameter values for the control names.
The controls exist on the report.
Each control is referenced in two other places. One where it is used to
create a row total, and one in a group footer to sum the group.
I have used Rick Fisher's Find and Replace Add In with the control names.
It finds them where they are defined or referenced.
If I enter a value of 1 in the parameter prompt, the correct value of the
table field shows in the control, but the group total is the number of detail
lines in the report. (20 line, group total = 20)

I could use some assistance with this one.
 
Are you attempting to Sum or Count a control rather than a field from your
report's record source? If so, this won't work. You need to Count or Sum
expressions from fields in your report's record source.
 
Thanks, Duane. While I was waiting, I found that to be the case. It has
been a while since I had to do a report. I always had someone else always
did them because I hate doing reports and had forgotten you can do adds and
subtracts but not sums and counts.
 
Klatuu said:
five texboxes on my report are causing problems. When I run the report I am
prompted for parameter values for the control names.
The controls exist on the report.
Each control is referenced in two other places. One where it is used to
create a row total, and one in a group footer to sum the group.
I have used Rick Fisher's Find and Replace Add In with the control names.
It finds them where they are defined or referenced.
If I enter a value of 1 in the parameter prompt, the correct value of the
table field shows in the control, but the group total is the number of detail
lines in the report. (20 line, group total = 20)
Click to expand...


The problem is that you are trying to use an aggregate
function (Count, Sum, etc) to operate on a control's value.
The aggregate functions only operate on **fields** in the
report's record source table/query.
 
Back
Top