how to hide a field?

[mahsa878]

I have created a query that will create a table automatically. I want one of the fields that I have defined in the query, not to show up on the table. the purpose of that field is just to check a minimum value so that the field next to it can use the value.
when I uncheck the "show" box in design view the field completely disappears and Access asks the user to enter a value for that name since the value is used in the field next to it.
PLEASE HELP!

 

[boblarson]

Don't use a make table query. Just create the table once, delete the extra field and then use a DELETE query to clear out the table and an APPEND query to populate it.

 

[mahsa878]

Don't use a make table query. Just create the table once, delete the extra field and then use a DELETE query to clear out the table and an APPEND query to populate it.

can I do the delete and update with just one query?
so it is not possible to just make Access not show the data calculated by that field in the final results?
sorry I'm pretty new to Access

 

[boblarson]

can I do the delete and update with just one query?

No, it is two separate queries.

so it is not possible to just make Access not show the data calculated by that field in the final results?

It isn't that it isn't necessarily possible but it is not a good method to do make table queries unless absolutely necessary.

 

[mahsa878]

No, it is two separate queries.

It isn't that it isn't necessarily possible but it is not a good method to do make table queries unless absolutely necessary.

how do you do it?

 

[boblarson]

how do you do it?

If you don't know how to make a delete query or an append query, you should go read this:
http://www.functionx.com/access/Lesson31.htm

This goes into action queries. The Append query is about half way down the page and the Delete query comes just after it in the tutorial.

 

[Pat Hartman]

Unchecking the Show box will not make Access prompt for the field. The problem may be that you are aggregating data and if you do that, the query engine assumes you want a HAVING clause rather than a WHERE clause so you will need to change that also. The WHERE clause is applied BEFORE the data is aggregated whereas the HAVING is applied AFTER the data is aggregated. Therefore, if you "hide" the field it won't be returned by the query and so the HAVING clause won't find it and so will prompt.

WHERE is used to filter the source data and HAVING is used to filter the resulting aggregated data.

 

[Mihail]

Hello everyone !
@Pat

The problem may be that you are aggregating data and if you do that, the query engine assumes you want a HAVING clause rather than a WHERE clause so you will need to change that also.

Is there any way to change this in query design window or only in the SQL view ?
Thank you.

 

[boblarson]

Hello everyone !
@Pat

Is there any way to change this in query design window or only in the SQL view ?
Thank you.

You can change it in the QBE grid by simply changing the drop down that says

GROUP BY

under the field to

WHERE

That will remove the X from the SHOW for showing the field, so If you need the field to be included just add the field again but without the criteria and leave the Group By in that one.