Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Aug 2002
    Location
    Orange Park, Florida, United Arab Emirates
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Update Query (A2K/WinXP Pro)

    Have 2 tables, one contains names, addresses, etc. The second contains a field with telephone number and address combined. Using a select query with both table joined by a key ID field I am able to create a field "PhoneNo" by using the Left function to separate the telephone number. When I change the query to an update query and set the update to a field PhoneNo in table one, I get an error message that says the Left function is not a valid name, yet it performs in the select query. Any suggestions as to what I may be doing wrong?

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

    Re: Update Query (A2K/WinXP Pro)

    Why don't you post your Update query SQL so we can all take a look at it.
    Someone will probably be able to help you.
    Pat <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Update Query (A2K/WinXP Pro)

    Update queries can only work on fields that exist. When you create a "field" in a select query, you're actually calculating and expression and showing it as if it really were a field in the underlying table. That isn't the same thing as trying to create a PhoneNo field in an update query..
    Charlotte

  4. #4
    New Lounger
    Join Date
    Aug 2002
    Location
    Orange Park, Florida, United Arab Emirates
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Update Query (A2K/WinXP Pro)

    Taking Charlotte's advice, I changed the query to a make table query that resulted in a table containing the phone number section and the ID fields. I then was able to update the original table. Thank You! I was beginning to get frustrated. Again, many thanks.

Posting Permissions

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