Results 1 to 9 of 9
  1. #1
    4 Star Lounger
    Join Date
    Feb 2006
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Update value (2003)

    Hi,

    I have about 35 different fields with the similar value (such as Y, N) in my database. Now I have to update Y to 1 and N to 0 in all of 35 fields.

    So what's the best way to update it?

    Thanks in advance.

    Regards,

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Update value (2003)

    Why do you want to do this?

    Are they all in the same table?

  3. #3
    4 Star Lounger
    Join Date
    Feb 2006
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Update value (2003)

    Hi,

    That's requirement of another system import specs. I will export it to txt file.

    Yes, they all are in the same table.

    Thanks,

  4. #4
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Update value (2003)

    Does the other system link to this system and get the data that way?

    Why not just build the query substituting the valu in the query? Or do you have to make a permanent change?

    There's no easy way to do it, well not that i'm aware of anyway.

  5. #5
    4 Star Lounger
    Join Date
    Feb 2006
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Update value (2003)

    So do I have to use update query and select all 35 fields to update it?

    Is there any better way to replace those value on all of 35 fields?

    Thanks,

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Update value (2003)

    You'd need lots of update queries because of the incorrect design of the table. It's probably easier to open the table in the Access interface and to use Edit | Replace, setting Look in to the table, and Match to Whole field. First replace Y with 1, then replace N with 0.

  7. #7
    4 Star Lounger
    Join Date
    Feb 2006
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Update value (2003)

    Thanks, Hans.

    But I never use the Access interface, can you provide more detail of how to open and edit it? Do I open the table in view?

    Thanks again.

    Regards,

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Update value (2003)

    Open the database.
    If necessary, activate the Tables section of the Database window.
    Double-click the table to open it.

  9. #9
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Update value (2003)

    How many tables are involved ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •