Query

[Gambler]

I was making a query and I unchecked some boxes in the design view so they wouldnt be printed out. I got out of my query and back in and the boxes I unchecked are gone from the query. Is this how access 2000 works or Is there any way to bring them back.
Thanks ed

[Rick]

There are multiple ways to add fields to the bottom.

The one I like best is to drag the field down from the list the place I want it.

You can also double click on the field name.

You can also click on the drop down arrow in a blank field box.

[Donnie]

Ed---unless you have any criteria in there to define a "selection" the query will remove that field that you are not showing as you save and close the query. An easy fix for this is take all the fields where you have unchecked the show box and add an * to the criteria field under each. Now when you save and close the query, those fields remain intact.

[MikeDee]

Ed, to add to Ricks coment, you can make the criteria so big that it will always include every horse. For example if it is a number field you can say <=10000. there by insuring every horse will qualify