Query Fileds Are Hidden

[Learn2010]

Trying to help an associate. Had a quick look. In design view, you see all the query fields. In datasheet view you don't see all of them. How can you unhide a field in a query?

 

[pbaldy]

In design view there's a "Show" checkbox.

 

[CJ_London]

or in datasheet view, right click on any column heading, select 'unhide' and then select the hidden columns

 

[Learn2010]

Thanks. I had to leave and I will take a look at it in the morning, CST.

 

[Learn2010]

I found the Unhide and Hide options. Thanks for all your help.