What you reported back are not the names of the controls; you reported
the
control source of the controls.
Check the Other tab of your controls and you should see a name property.
It may
be the same as the name of the control source. If it is the same, try
adding
"txt" to the beginning of the name.
If you have a control with the same name as a field then Access can get
confused. It will get confused when you attempt to refer to the name in
another
control. So try renaming the control(s).
Anita wrote:
This should make more sense as to what I'm trying to do....
I have a report that has on it the question, "The materials used in the
training were...." I have 65 people that responded to this question.
Of
those 65, 71 said 'good', which equates to 46%. As you already know,
the
percentage is coming out -46%.
When I go into design view, the name of the control under the 71 is
SumOfQ1good and the name of the control under the -46% is
=Abs([SumOfQ1good])/[CountOfRespondentNumber]
How can I tell if I have CountOfRespondentNumber as a field in the
report's
record source and/or CountOfRespondentNumber (field) as the control
source of
a control? I don't think I do since this info pulls from a query and
when I
click on the record source I get qryRespondentCourseTrainerDate as the
record
source.
Does this help?
--
Anita
:
Ok, let's back up a bit.
What are the names of the two controls?
Do you have SumOfQ1Good as a field in the report's record source?
Do you have SumOfQ1Good (field) as the control source of a control?
Do you have CountOfRespondentNumber as a field in the report's record
source?
Do you have CountOfRespondentNumber (field) as the control source of
a
control?
Sigh.... I'm beginning to think these two items are against me....
Now it's giving me 'Error' under both the number of respondents and
the
percentage. My control sources are:
=Abs([SumOfQ1Good]) - under # of Respondents
=Abs([SumOfQ1Good])/[CountOfRespondentNumber] - under percentage
What should I try next?
Thanks for all of your help with this; I really appreciate it.
--
Anita
:
I'm not seeing what could cause the problem.
Make sure your control is not named SumOfQ1Good
Make sure you have an equals sign before Abs(SumOfQ1Good)
Make sure you haven't misspelled SumOfQ1Good <--- This is most
often the
cause of a parameter prompt appearing. Often it will be a space
within
the
name. That is sometimes very difficult for my old eyes to see.
John,
I've tried entering:
Abs(SumOfQ1Good)
This takes the negative away, but it then asks for a Parameter
Value.
I've
even tried to copy the other Control Sources which have the same
exact
wording except for the 'good' (it's either 'excellent', 'fair'
or
'poor')
and
it's fine. It's just this Control Source.
Any other suggestions?
Thanks and have a great weekend!
--
Anita
:
It strips the negative sign, but now it asks me to enter a
parameter
value.
--
Anita
:
Use the ABS function on it. Abs is the ABSolute function
which
strips
off
the negative sign. So
Abs(SumOfQ1Good) should return a positive number
John,
Thanks! That fixed the negative in my percentages.
What do I need to change to fix the negative in my number
of
respondents?
The Control Source on that is:
SumOfQ1good
Thanks!
--
Anita
:
Try
=Abs([SumOfQ1good])/[CountOfRespondentNumber]
Your expression was comparing
[SumOfQ1good] To
Abs([SumOfQ1good])/[CountOfRespondentNumber]
and returning false (0) since the two were probably never
equal
I copied that into the Control Source so that my Control
Source
now
read:
=[SumOfQ1good]=Abs([SumOfQ1good])/[CountOfRespondentNumber]
All it gave me were zeros as my percentage. I didn't
even try
it
with
my
other Control Source (SumOfQ1good). Is there something
else I
need to
try?
Thanks!
--
Anita
:
Hello, Anita,
Apparently you're adding a Boolean field (yes/no),
where false
=
0 and
true =
-1. That's valid, no problem. But when you come up with
your
sum,
such
as -3,
add the following line of code:
SumOfQ1good = Abs(SumOfQ1good)
This returns the absolute value of the variable, and
it's
always
positive.
Repeat this code for every Boolean field you're adding.
Hope this helps,
Sam
Anita wrote:
I have a form that populates a report with a number of
respondents
and a
percentage (ex. 7 people said 'Excellent' and that's
70%, 3
people
said
'Good' and that is 30%, etc.). The 7, 70, 3 and 30
are the
numbers
that
are
coming out as negatives. The control sources are:
For the 3 it's: SumOfQ1good
For the 30% it's:
=[SumOfQ1good]/[CountOfRespondentNumber]
I've tried entering the control as
=[SumOfQ1good]/[CountOfRespondentNumber]-1, but it
doesn't
seem
to be
working.
I also have one line in my report that's not
populating at
all.
What do I need to do????
Thanks!
Anita
