Prev: mail merge with Word and Access Query
Next: Filter asterisks from a field
From: David W. Fenton on 21 Feb 2010 00:36
John W. Vinson <jvinson(a)STOP_SPAM.WysardOfInfo.com> wrote in
news:0dk0o51mbm3j1u41jnq4nl47sl9elspm6u(a)4ax.com:

> On Sat, 20 Feb 2010 11:18:01 -0800, Steve S
> <SteveS(a)discussions.microsoft.com> wrote:
>
>>The following appends all 15 fields but I want to exclude Fld3.
>>
>>INSERT INTO Fees
>>SELECT Fees.*
>>FROM Fees
>>WHERE (((Fees.ContestID)=9));
>>
>>
>>Is there a way to do this without listing out all 14 fields I do
>>want appended?
>
> As Rick says, no; but there's a quick way to add all the fields.
>
> 1. Add the table to the query design window.
> 2. Click the first field so it's selected.
> 3. Hold the Shift key and the arrow down key to select all fields.
> 4. Drag to the grid.

Or:

1. select the first field.
2. SHIFT-click the last field.
3. CTRL-click any field you want to exclude.
4. drag to the grid.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
First  |  Prev  | 
Pages: 1 2
Prev: mail merge with Word and Access Query
Next: Filter asterisks from a field