How to select all fields but one

  • Thread starter Thread starter Chaplain Doug
  • Start date Start date
C

Chaplain Doug

I am doing an append query as follows:

INSERT INTO [Students Archive] SELECT * FROM [Students]
WHERE Selected=True;

I am using an * which copies all fields. Instead, I want
to copy all fields except the "Selected" field. Is there
a way to do this without having to put all the field names
(minus the "Selected" field) in the query?
 
Chaplain Doug said:
I am doing an append query as follows:

INSERT INTO [Students Archive] SELECT * FROM [Students]
WHERE Selected=True;

I am using an * which copies all fields. Instead, I want
to copy all fields except the "Selected" field. Is there
a way to do this without having to put all the field names
(minus the "Selected" field) in the query?
Click to expand...

No.
 
Back
Top