Disable query field?

[b-ballstyle]

Is there a way to disable a query field (Not only hide it), so when I run the query and see the datasheet view, it doesn't take charge of that field and doesn't display it. I would like to be able to trigger (Enable/disable) some fields with a button or a check box maybe? Is it possible?

Example:
Picture 1 : The "Production Center" field is enabled


Picture 2 : The "Production Center" field is disabled (I just removed it from the query)

[Robeen]

I Query Design View - there is a check box under each of the fields you selected for the query. If you uncheck it - the field will not display when you run the query.

Is that what you needed?

[b-ballstyle]

No because that will only hide it from the datasheet view but I want to disable it.. The thing is, I'm using 4 tables to make that query .. Take a look at it maybe you will understand more why I cant just hide it.