clarify display / show query

  • Thread starter Thread starter Jimbo
  • Start date Start date
J

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
 
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.
 
Back
Top