select * from mytable except ...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to select all columns from a table except one, without
specifically naming all the desired columns?

Thanks.
 
I don't think there is a way of doing that, but if you want to use this table
in few places, and you don't want to specify the list of the fields every
time, then create a query that list all the desired fields and then use this
query instead of the table, so it will list all the fields except one.
 
Hi,


In the query designer, double click on the table, all fields will be
selected. Drag them into the grid, they will be all there, by name (rather
than with * ). So, you now can remove the field you don't want.


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top