|
|
I know this is a common problem, but I haven't been able to find a solution
by reading through past Discussions. The "Enter Parameter Value" box pops up
when I try to view my report. I don't need to enter any parameters,
therefore I don't want this box coming up. It is looking for the "Price"
parameter.
The name of the control (text box) is "Price". The Control Source is:
=IIf([ProposalStage]="Won",[POTotalPrice],[AsBidBasePrice])
If I just click OK on the Enter Parameter box, the report shows the correct
data based on the expression. From past problems, I know that I have to name
the Text Box something different from the field names. But obviously the
report is looking for value associated with the name of the control.
The query upon which the report is based works fine. It includes the
[POTotalPrice] and [AsBidBasePrice] fields.
I'm sure the solution is simple for those of you who know it! Why is it
looking for a value for "Price" and how do I stop this?
Thank you for your help.
- Diane
|
|
On Wed, 18 Jan 2006 09:11:35 -0800, DiHo wrote:
[Quoted Text] > I know this is a common problem, but I haven't been able to find a solution
> by reading through past Discussions. The "Enter Parameter Value" box pops up
> when I try to view my report. I don't need to enter any parameters,
> therefore I don't want this box coming up. It is looking for the "Price"
> parameter.
>
> The name of the control (text box) is "Price". The Control Source is:
>
> =IIf([ProposalStage]="Won",[POTotalPrice],[AsBidBasePrice])
>
> If I just click OK on the Enter Parameter box, the report shows the correct
> data based on the expression. From past problems, I know that I have to name
> the Text Box something different from the field names. But obviously the
> report is looking for value associated with the name of the control.
>
> The query upon which the report is based works fine. It includes the
> [POTotalPrice] and [AsBidBasePrice] fields.
>
> I'm sure the solution is simple for those of you who know it! Why is it
> looking for a value for "Price" and how do I stop this?
> Thank you for your help.
> - Diane
>
If the query is OK with the prompt, then it is coming from the report.
The usual culprit is the Report's Sorting and Grouping dialog. You may
have once had a reference there to a [Price] field that has since been
removed from the report but not from the Sorting and Grouping dialog
box.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
|
|
Fred,
Thanks, but ... I never had a field named "Price", and I've never sorted or
grouped on any of the fields related to price. Any other ideas?
Thanks!
Diane
"fredg" wrote:
[Quoted Text] > On Wed, 18 Jan 2006 09:11:35 -0800, DiHo wrote:
>
> > I know this is a common problem, but I haven't been able to find a solution
> > by reading through past Discussions. The "Enter Parameter Value" box pops up
> > when I try to view my report. I don't need to enter any parameters,
> > therefore I don't want this box coming up. It is looking for the "Price"
> > parameter.
> >
> > The name of the control (text box) is "Price". The Control Source is:
> >
> > =IIf([ProposalStage]="Won",[POTotalPrice],[AsBidBasePrice])
> >
> > If I just click OK on the Enter Parameter box, the report shows the correct
> > data based on the expression. From past problems, I know that I have to name
> > the Text Box something different from the field names. But obviously the
> > report is looking for value associated with the name of the control.
> >
> > The query upon which the report is based works fine. It includes the
> > [POTotalPrice] and [AsBidBasePrice] fields.
> >
> > I'm sure the solution is simple for those of you who know it! Why is it
> > looking for a value for "Price" and how do I stop this?
> > Thank you for your help.
> > - Diane
> >
>
> If the query is OK with the prompt, then it is coming from the report.
> The usual culprit is the Report's Sorting and Grouping dialog. You may
> have once had a reference there to a [Price] field that has since been
> removed from the report but not from the Sorting and Grouping dialog
> box.
> --
> Fred
> Please respond only to this newsgroup.
> I do not reply to personal e-mail
>
|
|
My guess is that you have attempted to Sum your Price text box in a group or
report footer. This doesn't work. You would need to Sum the expression:
=Sum(IIf([ProposalStage]="Won",[POTotalPrice],[AsBidBasePrice]))
--
Duane Hookom
MS Access MVP
--
"DiHo" <DiHo[ at ]discussions.microsoft.com> wrote in message
news:760A83DC-9CD1-4EC4-A290-13AEFC21F01C[ at ]microsoft.com...
[Quoted Text] > Fred,
> Thanks, but ... I never had a field named "Price", and I've never sorted
> or
> grouped on any of the fields related to price. Any other ideas?
> Thanks!
> Diane
>
> "fredg" wrote:
>
>> On Wed, 18 Jan 2006 09:11:35 -0800, DiHo wrote:
>>
>> > I know this is a common problem, but I haven't been able to find a
>> > solution
>> > by reading through past Discussions. The "Enter Parameter Value" box
>> > pops up
>> > when I try to view my report. I don't need to enter any parameters,
>> > therefore I don't want this box coming up. It is looking for the
>> > "Price"
>> > parameter.
>> >
>> > The name of the control (text box) is "Price". The Control Source is:
>> >
>> > =IIf([ProposalStage]="Won",[POTotalPrice],[AsBidBasePrice])
>> >
>> > If I just click OK on the Enter Parameter box, the report shows the
>> > correct
>> > data based on the expression. From past problems, I know that I have to
>> > name
>> > the Text Box something different from the field names. But obviously
>> > the
>> > report is looking for value associated with the name of the control.
>> >
>> > The query upon which the report is based works fine. It includes the
>> > [POTotalPrice] and [AsBidBasePrice] fields.
>> >
>> > I'm sure the solution is simple for those of you who know it! Why is
>> > it
>> > looking for a value for "Price" and how do I stop this?
>> > Thank you for your help.
>> > - Diane
>> >
>>
>> If the query is OK with the prompt, then it is coming from the report.
>> The usual culprit is the Report's Sorting and Grouping dialog. You may
>> have once had a reference there to a [Price] field that has since been
>> removed from the report but not from the Sorting and Grouping dialog
>> box.
>> --
>> Fred
>> Please respond only to this newsgroup.
>> I do not reply to personal e-mail
>>
|
|
On Wed, 18 Jan 2006 09:41:27 -0800, DiHo wrote:
[Quoted Text] > Fred,
> Thanks, but ... I never had a field named "Price", and I've never sorted or
> grouped on any of the fields related to price. Any other ideas?
> Thanks!
> Diane
>
> "fredg" wrote:
>
>> On Wed, 18 Jan 2006 09:11:35 -0800, DiHo wrote:
>>
>>> I know this is a common problem, but I haven't been able to find a solution
>>> by reading through past Discussions. The "Enter Parameter Value" box pops up
>>> when I try to view my report. I don't need to enter any parameters,
>>> therefore I don't want this box coming up. It is looking for the "Price"
>>> parameter.
>>>
>>> The name of the control (text box) is "Price". The Control Source is:
>>>
>>> =IIf([ProposalStage]="Won",[POTotalPrice],[AsBidBasePrice])
>>>
>>> If I just click OK on the Enter Parameter box, the report shows the correct
>>> data based on the expression. From past problems, I know that I have to name
>>> the Text Box something different from the field names. But obviously the
>>> report is looking for value associated with the name of the control.
>>>
>>> The query upon which the report is based works fine. It includes the
>>> [POTotalPrice] and [AsBidBasePrice] fields.
>>>
>>> I'm sure the solution is simple for those of you who know it! Why is it
>>> looking for a value for "Price" and how do I stop this?
>>> Thank you for your help.
>>> - Diane
>>>
>>
>> If the query is OK with the prompt, then it is coming from the report.
>> The usual culprit is the Report's Sorting and Grouping dialog. You may
>> have once had a reference there to a [Price] field that has since been
>> removed from the report but not from the Sorting and Grouping dialog
>> box.
>> --
>> Fred
>> Please respond only to this newsgroup.
>> I do not reply to personal e-mail
>>
1) Once again, did you actually look in Sorting and Grouping? Don't
assume.
2) Somewhere in your report you have a control with a control source
expression, something similar to = [Price] * [Tax] and the field price
is not included in that section or in the report record source. You'll
have to look. Look for miss-spelled words, etc. It's there...
somewhere.
3) You write that you have a control named "Price". What happens if
you change that control name to "txtPrice",
Do you still get a prompt? Is the prompt now asking for 'txtPrice'
instead of Price?
4) When you do get that prompt try entering a strange bit of data,
such as 99999. See if that affects your report in any way.
5) Check your code. It may be in one of the report event's code.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
|
|
Duane,
You're absolutely correct! That's what was happening, and when I inserted
the expression that you suggested, it worked fine. Thank you! Why doesn't
someone like you sit in the office next to me?!?
- Diane
"Duane Hookom" wrote:
[Quoted Text] > My guess is that you have attempted to Sum your Price text box in a group or
> report footer. This doesn't work. You would need to Sum the expression:
> =Sum(IIf([ProposalStage]="Won",[POTotalPrice],[AsBidBasePrice]))
>
>
> --
> Duane Hookom
> MS Access MVP
> --
>
> "DiHo" <DiHo[ at ]discussions.microsoft.com> wrote in message
> news:760A83DC-9CD1-4EC4-A290-13AEFC21F01C[ at ]microsoft.com...
> > Fred,
> > Thanks, but ... I never had a field named "Price", and I've never sorted
> > or
> > grouped on any of the fields related to price. Any other ideas?
> > Thanks!
> > Diane
> >
> > "fredg" wrote:
> >
> >> On Wed, 18 Jan 2006 09:11:35 -0800, DiHo wrote:
> >>
> >> > I know this is a common problem, but I haven't been able to find a
> >> > solution
> >> > by reading through past Discussions. The "Enter Parameter Value" box
> >> > pops up
> >> > when I try to view my report. I don't need to enter any parameters,
> >> > therefore I don't want this box coming up. It is looking for the
> >> > "Price"
> >> > parameter.
> >> >
> >> > The name of the control (text box) is "Price". The Control Source is:
> >> >
> >> > =IIf([ProposalStage]="Won",[POTotalPrice],[AsBidBasePrice])
> >> >
> >> > If I just click OK on the Enter Parameter box, the report shows the
> >> > correct
> >> > data based on the expression. From past problems, I know that I have to
> >> > name
> >> > the Text Box something different from the field names. But obviously
> >> > the
> >> > report is looking for value associated with the name of the control.
> >> >
> >> > The query upon which the report is based works fine. It includes the
> >> > [POTotalPrice] and [AsBidBasePrice] fields.
> >> >
> >> > I'm sure the solution is simple for those of you who know it! Why is
> >> > it
> >> > looking for a value for "Price" and how do I stop this?
> >> > Thank you for your help.
> >> > - Diane
> >> >
> >>
> >> If the query is OK with the prompt, then it is coming from the report.
> >> The usual culprit is the Report's Sorting and Grouping dialog. You may
> >> have once had a reference there to a [Price] field that has since been
> >> removed from the report but not from the Sorting and Grouping dialog
> >> box.
> >> --
> >> Fred
> >> Please respond only to this newsgroup.
> >> I do not reply to personal e-mail
> >>
>
>
>
|
|
Fred,
My problem was as Duane described it. Thanks for all your help!
-Diane
"fredg" wrote:
[Quoted Text] > On Wed, 18 Jan 2006 09:41:27 -0800, DiHo wrote:
>
> > Fred,
> > Thanks, but ... I never had a field named "Price", and I've never sorted or
> > grouped on any of the fields related to price. Any other ideas?
> > Thanks!
> > Diane
> >
> > "fredg" wrote:
> >
> >> On Wed, 18 Jan 2006 09:11:35 -0800, DiHo wrote:
> >>
> >>> I know this is a common problem, but I haven't been able to find a solution
> >>> by reading through past Discussions. The "Enter Parameter Value" box pops up
> >>> when I try to view my report. I don't need to enter any parameters,
> >>> therefore I don't want this box coming up. It is looking for the "Price"
> >>> parameter.
> >>>
> >>> The name of the control (text box) is "Price". The Control Source is:
> >>>
> >>> =IIf([ProposalStage]="Won",[POTotalPrice],[AsBidBasePrice])
> >>>
> >>> If I just click OK on the Enter Parameter box, the report shows the correct
> >>> data based on the expression. From past problems, I know that I have to name
> >>> the Text Box something different from the field names. But obviously the
> >>> report is looking for value associated with the name of the control.
> >>>
> >>> The query upon which the report is based works fine. It includes the
> >>> [POTotalPrice] and [AsBidBasePrice] fields.
> >>>
> >>> I'm sure the solution is simple for those of you who know it! Why is it
> >>> looking for a value for "Price" and how do I stop this?
> >>> Thank you for your help.
> >>> - Diane
> >>>
> >>
> >> If the query is OK with the prompt, then it is coming from the report.
> >> The usual culprit is the Report's Sorting and Grouping dialog. You may
> >> have once had a reference there to a [Price] field that has since been
> >> removed from the report but not from the Sorting and Grouping dialog
> >> box.
> >> --
> >> Fred
> >> Please respond only to this newsgroup.
> >> I do not reply to personal e-mail
> >>
>
> 1) Once again, did you actually look in Sorting and Grouping? Don't
> assume.
>
> 2) Somewhere in your report you have a control with a control source
> expression, something similar to = [Price] * [Tax] and the field price
> is not included in that section or in the report record source. You'll
> have to look. Look for miss-spelled words, etc. It's there...
> somewhere.
>
> 3) You write that you have a control named "Price". What happens if
> you change that control name to "txtPrice",
> Do you still get a prompt? Is the prompt now asking for 'txtPrice'
> instead of Price?
>
> 4) When you do get that prompt try entering a strange bit of data,
> such as 99999. See if that affects your report in any way.
>
> 5) Check your code. It may be in one of the report event's code.
> --
> Fred
> Please respond only to this newsgroup.
> I do not reply to personal e-mail
>
|
|
How much do you pay and where are you ;-)
--
Duane Hookom
MS Access MVP
--
"DiHo" <DiHo[ at ]discussions.microsoft.com> wrote in message
news:4BC2E463-50CD-4AB6-9CEF-880CC2740EB4[ at ]microsoft.com...
[Quoted Text] > Duane,
> You're absolutely correct! That's what was happening, and when I inserted
> the expression that you suggested, it worked fine. Thank you! Why
> doesn't
> someone like you sit in the office next to me?!?
> - Diane
>
> "Duane Hookom" wrote:
>
>> My guess is that you have attempted to Sum your Price text box in a group
>> or
>> report footer. This doesn't work. You would need to Sum the expression:
>> =Sum(IIf([ProposalStage]="Won",[POTotalPrice],[AsBidBasePrice]))
>>
>>
>> --
>> Duane Hookom
>> MS Access MVP
>> --
>>
>> "DiHo" <DiHo[ at ]discussions.microsoft.com> wrote in message
>> news:760A83DC-9CD1-4EC4-A290-13AEFC21F01C[ at ]microsoft.com...
>> > Fred,
>> > Thanks, but ... I never had a field named "Price", and I've never
>> > sorted
>> > or
>> > grouped on any of the fields related to price. Any other ideas?
>> > Thanks!
>> > Diane
>> >
>> > "fredg" wrote:
>> >
>> >> On Wed, 18 Jan 2006 09:11:35 -0800, DiHo wrote:
>> >>
>> >> > I know this is a common problem, but I haven't been able to find a
>> >> > solution
>> >> > by reading through past Discussions. The "Enter Parameter Value"
>> >> > box
>> >> > pops up
>> >> > when I try to view my report. I don't need to enter any parameters,
>> >> > therefore I don't want this box coming up. It is looking for the
>> >> > "Price"
>> >> > parameter.
>> >> >
>> >> > The name of the control (text box) is "Price". The Control Source
>> >> > is:
>> >> >
>> >> > =IIf([ProposalStage]="Won",[POTotalPrice],[AsBidBasePrice])
>> >> >
>> >> > If I just click OK on the Enter Parameter box, the report shows the
>> >> > correct
>> >> > data based on the expression. From past problems, I know that I have
>> >> > to
>> >> > name
>> >> > the Text Box something different from the field names. But
>> >> > obviously
>> >> > the
>> >> > report is looking for value associated with the name of the control.
>> >> >
>> >> > The query upon which the report is based works fine. It includes
>> >> > the
>> >> > [POTotalPrice] and [AsBidBasePrice] fields.
>> >> >
>> >> > I'm sure the solution is simple for those of you who know it! Why
>> >> > is
>> >> > it
>> >> > looking for a value for "Price" and how do I stop this?
>> >> > Thank you for your help.
>> >> > - Diane
>> >> >
>> >>
>> >> If the query is OK with the prompt, then it is coming from the report.
>> >> The usual culprit is the Report's Sorting and Grouping dialog. You may
>> >> have once had a reference there to a [Price] field that has since been
>> >> removed from the report but not from the Sorting and Grouping dialog
>> >> box.
>> >> --
>> >> Fred
>> >> Please respond only to this newsgroup.
>> >> I do not reply to personal e-mail
>> >>
>>
>>
>>
|
|
The "Enter Parameter Value" box appears. The text box is in the report
footer. I added "sum" to the beginning of the expression. When the report is
run, it returns 40 rather than 4, appearing to add numbers rather than
returning the number for the risk level.
E/ Risk Level=sum(IIf([ErrorRate
Percentage]<=0.15,"1",(IIf([ErrorRatePercentage]<=0.25,"2",(IIf([ErrorRatePercentage]<=0.35,"3",(IIf([ErrorRatePercentage]<0.5,"4","5"))))))))
Suggestions?
"Duane Hookom" wrote:
[Quoted Text] > My guess is that you have attempted to Sum your Price text box in a group or
> report footer. This doesn't work. You would need to Sum the expression:
> =Sum(IIf([ProposalStage]="Won",[POTotalPrice],[AsBidBasePrice]))
>
>
> --
> Duane Hookom
> MS Access MVP
> --
>
> "DiHo" <DiHo[ at ]discussions.microsoft.com> wrote in message
> news:760A83DC-9CD1-4EC4-A290-13AEFC21F01C[ at ]microsoft.com...
> > Fred,
> > Thanks, but ... I never had a field named "Price", and I've never sorted
> > or
> > grouped on any of the fields related to price. Any other ideas?
> > Thanks!
> > Diane
> >
> > "fredg" wrote:
> >
> >> On Wed, 18 Jan 2006 09:11:35 -0800, DiHo wrote:
> >>
> >> > I know this is a common problem, but I haven't been able to find a
> >> > solution
> >> > by reading through past Discussions. The "Enter Parameter Value" box
> >> > pops up
> >> > when I try to view my report. I don't need to enter any parameters,
> >> > therefore I don't want this box coming up. It is looking for the
> >> > "Price"
> >> > parameter.
> >> >
> >> > The name of the control (text box) is "Price". The Control Source is:
> >> >
> >> > =IIf([ProposalStage]="Won",[POTotalPrice],[AsBidBasePrice])
> >> >
> >> > If I just click OK on the Enter Parameter box, the report shows the
> >> > correct
> >> > data based on the expression. From past problems, I know that I have to
> >> > name
> >> > the Text Box something different from the field names. But obviously
> >> > the
> >> > report is looking for value associated with the name of the control.
> >> >
> >> > The query upon which the report is based works fine. It includes the
> >> > [POTotalPrice] and [AsBidBasePrice] fields.
> >> >
> >> > I'm sure the solution is simple for those of you who know it! Why is
> >> > it
> >> > looking for a value for "Price" and how do I stop this?
> >> > Thank you for your help.
> >> > - Diane
> >> >
> >>
> >> If the query is OK with the prompt, then it is coming from the report.
> >> The usual culprit is the Report's Sorting and Grouping dialog. You may
> >> have once had a reference there to a [Price] field that has since been
> >> removed from the report but not from the Sorting and Grouping dialog
> >> box.
> >> --
> >> Fred
> >> Please respond only to this newsgroup.
> >> I do not reply to personal e-mail
> >>
>
>
>
|
|
|