Enter Parameter Value

[Kristy McCool]

When moving from report design to report view, a box pops
up prompting us to enter parameter value. We have tried
entering the formula associated with the message in the
dialog box. Once the formula is entered we receive an
error message that says the expression is typed
incorrectly or is too complex....Can anyone help us
determine what needs to go in the dialog box?

 

[Fredg]

Kristy,

I don't know what you mean by

We have tried
entering the formula associated with the message in the
dialog box.

A parameter box asks for a value, not a formula.

If the Record Source for the Report is a parameter Query, then you are
getting the dialog box to enter the parameter values. Can't tell what's
wrong unless you post the entire query SQL, along with a sample value for
that field.

However, if you have mis-spelled a field name in a report control
expression, Access will ask for a value to place in that expression. Usually
this is caused by something simple, like writing =[Amont] when you meant to
write = [Amount].
You will have to check your report for the field used by the prompt.
Look carefully for that mis-spelled word.

Many time this occurs when a field has been entered in the Report's Sorting
and Grouping dialog, then subsequently removed from the report, without
having that field deleted from the dialog.
I would check there first.

 

[Kristy McCool]

Fred-
Thanks for your help, but i'm still not sure where i'm
going wrong. Here's a little more info on my situation.

I have a report for contract detail which lists each
contracht and the contract amount. In the design view of
the report i added a report footer which is where i put a
total so that we can see the total contract amount.

The formula for this total is where i'm running into
trouble (i think). The formula is =Sum([Current Month]!
[Contract Amount]). Current month is a table that we set
up. Now, when i try to view the report a box pops up that
says Enter Parameter Value in the title and in the grey
area says "Current Month!Contract Amount". I have tried
typing in many different things into the text area
(including the actual formula) and I always get a message
that says "The expression is typed incorrectly, or it is
too complex to be evaluated. For example, a numeric
expression may contain too many complicated elements. Try
simplifying the expression by assigning parts of the
expression to variables." Any other ideas as to what is
going wrong?

Thanks for your help!

-----Original Message-----
Kristy,

I don't know what you mean by

We have tried
entering the formula associated with the message in the
dialog box.

A parameter box asks for a value, not a formula.

If the Record Source for the Report is a parameter Query, then you are
getting the dialog box to enter the parameter values. Can't tell what's
wrong unless you post the entire query SQL, along with a sample value for
that field.

However, if you have mis-spelled a field name in a report control
expression, Access will ask for a value to place in that expression. Usually
this is caused by something simple, like writing =[Amont] when you meant to
write = [Amount].
You will have to check your report for the field used by the prompt.
Look carefully for that mis-spelled word.

Many time this occurs when a field has been entered in the Report's Sorting
and Grouping dialog, then subsequently removed from the report, without
having that field deleted from the dialog.
I would check there first.

--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.

When moving from report design to report view, a box pops
up prompting us to enter parameter value. We have tried
entering the formula associated with the message in the
dialog box. Once the formula is entered we receive an
error message that says the expression is typed
incorrectly or is too complex....Can anyone help us
determine what needs to go in the dialog box?

.

 

[Ian Tranter]

Sounds like you might have the name of the table or query
included in the formula
E.g.
Suppose you have a report tied to a query
called "MYQUERY" and you want to display the sum
of "MYVAL" + "YOURVAL" from it, then the control (text
box) might say.
=sum([MYQUERY]![MYVAL]+ [MYQUERY]![YOURVAL])

what you need to do is remove [MYQUERY]! From the calc as
the report is already tied to the query and dose not need
it & asks for the parameter value for MYQUERY.
I think, well it worked for me????

 

[Kristy McCool]

Looks like that did the trick. Thanks!

Kristy

-----Original Message-----
Sounds like you might have the name of the table or query
included in the formula
E.g.
Suppose you have a report tied to a query
called "MYQUERY" and you want to display the sum
of "MYVAL" + "YOURVAL" from it, then the control (text
box) might say.
=sum([MYQUERY]![MYVAL]+ [MYQUERY]![YOURVAL])

what you need to do is remove [MYQUERY]! From the calc as
the report is already tied to the query and dose not need
it & asks for the parameter value for MYQUERY.
I think, well it worked for me????

-----Original Message-----
When moving from report design to report view, a box pops
up prompting us to enter parameter value. We have tried
entering the formula associated with the message in the
dialog box. Once the formula is entered we receive an
error message that says the expression is typed
incorrectly or is too complex....Can anyone help us
determine what needs to go in the dialog box?
.

.