Expression prompt

[acss]

I have the following expression on my report:

=IIf(([VendorCtry] Like '*PERU*'),[ SumofSumOfInvAmt]*0.03,0)

The problem arises that when you run the report it gives a parameter prompt
for the user to enter in SumofSumOfInvAmt. What can be done in the expression
to prevent the prompt?

Thanks

 

[Allen Browne]

The request for a parameter indicates that Access can't resolve the name
requested in the parameter dialog.

It looks like there might be a leading space insie the square bracket. If
the name doesn't match exactly, you will get the parameter request.

Alternatively, if you don't have a text box named SumofSumOfInvAmt on your
report, add it (setting Visible to No if you wish.) The report optimiser
sometimes doesn't fetch fields if it doesn't see where they are used.

 

[Al Campagna]

acss,
See my response to your original post (in access.reports) of 2/9/2009 @
7:49AM.
Your last question in that thread deals directly with this question.

When you capture the Rate for each transaction, at transcation time,
this issue doesn't come into play.

Please don't start another post that deals with the, essentially, the
same issue in your original post. Responders are volunteers, and may not be
readily available to answer each new question in a thread right away, so a
bit of patience is required. If you and a responder decide that progress
isn't being made on that thread, then... it's legit to start a new post.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[acss]

Allen, in this expression i am tring to filter out one country for this
percentage since i have 3 other countries that InvAmt need to be subtracted
by 8 percent. The report has a grouping level per country and i have 3
countries that invoice amount needs to have 6 percent subtracted and one
country (PERU) that needs 3 percent subtracted. Is there an expression that
would filter one country from the rest while doing this calculation?

The request for a parameter indicates that Access can't resolve the name
requested in the parameter dialog.

It looks like there might be a leading space insie the square bracket. If
the name doesn't match exactly, you will get the parameter request.

Alternatively, if you don't have a text box named SumofSumOfInvAmt on your
report, add it (setting Visible to No if you wish.) The report optimiser
sometimes doesn't fetch fields if it doesn't see where they are used.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I have the following expression on my report:

=IIf(([VendorCtry] Like '*PERU*'),[ SumofSumOfInvAmt]*0.03,0)

The problem arises that when you run the report it gives a parameter
prompt
for the user to enter in SumofSumOfInvAmt. What can be done in the
expression
to prevent the prompt?

Thanks