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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access2000: Update query 6
minimize repeating query criteria & generating monthly YTD totals 1
VBA - retrieve data on last create named range from previous inserted named range 0
Concatenate Question 2
selecting nos from table 1
Query Inside an SQL statement 3
Query not returning null value 3
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0

Back
Top