clarify display / show query

[Jimbo]

Ladies and Gents,

Just wish to clarify my question regarding a query.

We have a screen form that has a tick box for history comments, if it is
ticked we want it to print out on the report.

In the query I have the tick box not to show and in the history comments I
want to put a statement in there that says if the tick box is True, display
/show the history comments when running the query which is linked to the
report.

Hope this is understandable.

Jim

 

[Jeff Boyce]

Jim

I've only now found this post, and have no idea what "question" you are
clarifying.

If you wish a field in your query to be empty if the form's "tick box" is
unchecked, or to display a field if the form's checkbox is checked, you can
use the IIF() function.