Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    Feb 2002
    Posts
    537
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Update table (Access 2000)

    I want to update all the records in the field Taxid of the table Customers with the letters BD at the beginning of the figures.Could you help me ? The autonumber of the table Customers is Customerid. For example for customerid the taxid = 87469999 i want to update it to read BD87469999.

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

    Re: Update table (Access 2000)

    Is the field already a text field? If not, change it to a text field first, and make sure that it is long enough.

    Create a query based on the Customers table.
    Add the Taxid field.
    Select Query | Update Query.
    Enter the following expression in the Update to line:
    <code>
    "BD" & [Taxid]
    </code>
    Select Query | Run.

  3. #3
    4 Star Lounger
    Join Date
    Feb 2002
    Posts
    537
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Update table (Access 2000)

    Thank you very much indeed

  4. #4
    4 Star Lounger
    Join Date
    Feb 2002
    Posts
    537
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Update table (Access 2000)

    It is a text field and your suggestion works excellent ! Just a small modification,i must not place the letters in case the field is blank.
    I must add the letters only when there are figures in it. In some rows there is no taxid written, and in this case the letters BD must not be added.What shall i write, something If it is not Null , and where ?

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

    Re: Update table (Access 2000)

    Open the query in design view, and enter

    Is Not Null

    in the Criteria line.

Posting Permissions

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