Re: select * from mytable except ...
- From: "Michel Walsh" <vanderghast@VirusAreFunnierThanSpam>
- Date: Tue, 31 Jan 2006 14:37:07 -0500
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
"Ofer" <Ofer@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D24B3556-6FF0-4776-97F6-F68AEB207670@xxxxxxxxxxxxxxxx
>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.
>
> --
> \\// Live Long and Prosper \\//
> BS"D
>
>
> "khalprin" wrote:
>
>> Is it possible to select all columns from a table except one, without
>> specifically naming all the desired columns?
>>
>> Thanks.
.
- Prev by Date: Re: Query to Count, but return items that are null
- Next by Date: Re: Union and variable
- Previous by thread: How do I prevent PivotTable Query from Being Saved
- Next by thread: Re: Union and variable
- Index(es):
Relevant Pages
|
|
