Re: number problem?

Tech-Archive recommends: Fix windows errors by optimizing your registry

"rob" <rob@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C124FCE4-3993-40B4-8564-D4DAE50EF293@xxxxxxxxxxxxxxxx
>I have a field in my database which contains 6 numbers ex: 123456. I want
>to
> break this number down, add another field and have one field 123 and the
> other field 456. Please help.


Add two fields to your table. Use the Left and Right functions in an update
query, to update the values in your table.

Left(YourField,3) and Right(YourField,3)

--
Joan Wild
Microsoft Access MVP


.

Relevant Pages

  • Re: Probs accessing database for users of newly developed Superuse
    ... "Joan Wild" wrote: ... Microsoft Access MVP ... but the SuperUsers cannot get into it. ... ' Minimize the database window and initialize the form. ...
    (microsoft.public.access.security)
  • Re: Able to open secured database with default MDW
    ... Microsoft Access MVP ... Susan L wrote: ... All this and I can still get into the database directly when using ... "Joan Wild" wrote: ...
    (microsoft.public.access.security)
  • Re: Access 2000 J Wild security procedure
    ... "Joan Wild" wrote: ... one of the steps is to import all the objects to a new database. ... Microsoft Access MVP ... In 97 you would get the login as soon as Access opens, ...
    (microsoft.public.access.security)
  • Re: Access 2000 J Wild security procedure
    ... Microsoft Access MVP ... JoAnne wrote: ... through the process of setting up a new database using the default ... "Joan Wild" wrote: ...
    (microsoft.public.access.security)
  • Re: unknown database owner
    ... "Joan Wild" wrote: ... the "owner is unknown" (you described ... An old database, ... Rick Brandt, Microsoft Access MVP ...
    (microsoft.public.access.security)