Re: Multiple data Update

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: James (info_at_N)_Spam_uk-discounts.com)
Date: 02/27/04 

Date: Fri, 27 Feb 2004 19:00:49 -0000

Hi John,

Sorry it is a field not a table.

I have a stack of data in fields that need to be moved from one field to
another based on the selection criteria in this case its an ID (196, 201,215
etc)

The only way have been able to do this latly is one at a time, which is vert
tidious, hence my request to enter multiple ID's in one selection.

Thanks
James

"John Vinson" <jvinson@STOP_SPAM.WysardOfInfo.com> wrote in message
news:9t5t301fl4q63smr2ptfmobp45ninklh5t@4ax.com...
> On Thu, 26 Feb 2004 22:38:17 -0000, "James"
> <info@N)_Spam_uk-discounts.com> wrote:
>
> >I need to update multipe selected records to a new field in the same
table
> >and wonder if it is possible via query window.
> >
> >What I Have bee doing is
> >
> >UPDATE tableA.[size01] = [size]
> >WHERE (((tableA) = 196));
> >
> >what I need is to add 196,201,215 etc
> >
> >they are not always in sequence and therefore cannot just say between 196
> >AND 215
> >
> >Any tipe or suggestions would be most welcome
> >
> >James
> >
>
> If you mean you want to use the *name of the table* itself as a
> parameter... you can't, and shouldn't. Storing data in a tablename is
> extremely bad design!
>
> Is that what you mean, or are you talking about *a field* in TableA?
>
> John W. Vinson[MVP]
> Come for live chats every Tuesday and Thursday
> http://go.compuserve.com/msdevapps?loc=us&access=public

Relevant Pages

  • Re: Eduard vs Roden WWI kits?
    ... Stephen Tontoni wrote: ... > I have a stack of Roden/Toko now and will get to it some day. ... > The selection in 1/72nd is a lot of fun. ...
    (rec.models.scale)
  • Window: Arrange All?
    ... When I have multiple documents loaded, the Window:Arrange All selection ... always displays a stack of horizontal windows. ... I haven't found a preference ...
    (microsoft.public.mac.office.word)
  • Re: Security Tab (name not found ? )
    ... partitions. ... An object named "Bee Bop" cannot be found. ... or remove this object from the selection. ...
    (microsoft.public.windowsxp.security_admin)
  • Re: Setting var to selected Range
    ... dim myRng as range ... set myrng = Range) ... set myrng = selection ... El Bee wrote: ...
    (microsoft.public.excel.misc)