How to select all fields but one

[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?

 

[Rick Brandt]

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?

No.