2007 version query problems

S

SusanJ

This is driving me nuts! When I run a select query, it outputs ALL the
fields & I only want to select some of them. And, when I run an append
query, it forces me to output ALL the fields, any only some of them get
appended to the out file. If I don't output the field, I get "Insert Into
statement contains the following unknown field name..." I don't know much
SQL and usually build them in design view. I never had this issue with
version 2003.

HELP! before I lose my mind.

Thanks
 
G

George Nicholson

Sounds like you may be using * in your SELECT clause ("SELECT *..."). Don't.
* instructs SQL to output all fields.

Specify only select the fields you want to output/append, separated by
commas.
 
Top