Solution for Selecting fields to create query in access, automatically adds asterisk * to the fields selected. It shows up in the SQL view, but not query design
is Given Below:
Query design in MS Access:
SQL view in MS Access:
This is due to an application setting.
File > Options > Object Designers > Query design > uncheck “Output all fields”
Turn off output all fields in the property sheet of query properties. it is on yes by default. So to turn it off permanently go to:
file at the upper right hand of the ribbon, click it, then at the bottom, options, then to object designers, then query designers, then uncheck the box> out put all fields