Make a Table from a Table - Excluding one field

[meagain]

Hi All,

I need to create a table from a table with a large number of fields, without including one field. Rather than dropping each field into a Make Table query, I'm wondering if there is a way to make a table and exclude a field, within the Make Table query?

Thanks!!

 

[dhookom]

When building your query, you can double-click the table name in the upper pane to select all fields. Then ctrl-click the field you want to exclude. Drag the remaining fields to the query grid.

Duane
Hook'D on Access
MS Access MVP