MS Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a client making a Query in Access 2003, when we check the SQL the
assrix is entered automatically causing all the fields to appear instead of
just the 5 selected. Tested on another PC and the "*" did not appear in the
SQL line.--
Thanks
Aron
 
I have a client making a Query in Access 2003, when we check the SQL the
assrix is entered automatically causing all the fields to appear instead of
just the 5 selected. Tested on another PC and the "*" did not appear in the
SQL line.--
Thanks
Aron
Click to expand...

In your Access Options you have "Output All Fields" checked On.
You can change that or on a query by query basis in Query Properties.
 
Back
Top