Help with query show checkmark

[nightangel73]

Okay I have a simple query. One of the columns is a simple calculated number (a substraction from one column to other). I do not want this column displayed in the query so I uncheck the show box. I click save and what happens is it deletes the column and screwes up the query prompting me for a parameter value. I want the column there but I just do want it displayed in the query. I though just unchecking the show box would make the column stay there but not deleted. If you uncheck and it deletes the column then what it is there for? I also went to Tool-Options- Table/Queries and unchecked the show table names to see if this would help. No luck. Please help

[ranman256]

Make sure under the field it says WHERE and is unchecked, but it also need a value in the critera.
Otherwise the SQL says its not used and deletes it.

[lfpm062010]

If the query is summary query, you can uncheck them and use the "WHERE" in place of "GROUP BY", "SUM", "COUNT", ... or "EXPRESSION". Then it will be saved.

If the query is a simple query, the only way to retain the calculated value is to have a criteria. Something like "<>0" or "IS NOT NULL", ... etc