Report from query problem (1 Viewer)

[evanhughes]

Hi All

I have this in my query which seems to work but it keeps asking for input when running report based on query.
The table field is yes/no.

Deposit Charge: IIf(

![Field]=True,Format("5","Currency"),Format("0","Currency"))

Any ideas why.

Evan

 

[Uncle Gizmo]

it keeps asking for input when running report based on query.

If the query is getting its information from a form, then the form needs to be open when the query is run. You may be in a situation where you think of the form is open, however the form may be closed before the query can capture the information it requires.

 

[CBrighton]

What does the input box say that it is asking for, is it asking for "Deposit Charge" or something within the IIF statement?

 

[evanhughes]

Yes it is asking for deposit charge.

Even when form and table are open.

There is nothing in the criteria so I am at a loss.

Evan

 

[CBrighton]

Silly question, but you are certain the query the report is bound to is the one with this calculated field?

 

[evanhughes]

Yes I'm sure. And It's not a silly question.

Evan

 

[CBrighton]

Deposit Charge: IIf(

![Field]=True,Format("5","Currency"),Format("0","Currency"))

You could try it the other way around.

Bind the field to a hidden checkbox then set the field you are currently using to hold the currency to have an IIf statement similar to the above but referencing the check box.