Expression keeps being deleted in query

[Trisha]

I have created an IIf statement that i dont want to show up in the query result, so i have unticked the "show" option as again i dont want it showing up on the result once the query is ran. But every time i untick it then save the query the expression is being deleted automatically, but when i leave it as showing up in the query result it saves fine and does not delete it as it would when it is unticked. Anyone with a solution to this funny?

 

[John Big Booty]

If you display the results of your query in a form rather than directly via the query, you can control exactly what you show your user.

Remember that query are a little like tables, and should only be seen by your user through the "filter" of a form.

 

[Trisha]

HI John Big Booty

I dont want it showing in the query result as it is used by other users and i just want it for a report result, i have a report that is linked to this query where i have an expression reading from the query result, if you know what i mean i just want it if you like running in the background.

 

[John Big Booty]

That is why the results of your query should be displayed in a from rather than directly in your Query. If you use your query as the Record Source of a form you can control exactly what your users sees and how they are able to interact with those results.