I have not had this issue before with the old .mdb but with 2007 Access ,
when I am creating or editing a query in design mode, I click or drag only
the field names I need, delete all others i dont need, but when I click on
the datasheet view - everything else in the tables I used on the query
appears - and I have to use hide options to hide them. Its not that hard at
first but when you keep doing it over and over it tends to get frustrating.
How do I get the query to show only the fields I lined up in the design mode?

--
Thank you very much.