Default * in query SQL.

C

CJ

Just converted to Access2003. All new queries created by either dragging
individual column names from tables or double clicking table name and
dragging all column into a query result with a wildcard * in the SQL as a
field name. If I remove it from the SQL, the query works correctly. I
reloaded the software so is this a bug or can it be "turn off"?
 
B

Brian

Tools -> Options -> Tables/Queries -> Output all fields? If this is checked,
it inserts the * automatically into the select statement when using the query
builder.
 
C

CJ

That was the problem. Thank you.

Brian said:
Tools -> Options -> Tables/Queries -> Output all fields? If this is checked,
it inserts the * automatically into the select statement when using the query
builder.
Click to expand...
 
Top