Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Brookline, Massachusetts, USA
    Posts
    606
    Thanks
    17
    Thanked 0 Times in 0 Posts
    I have two tables with the following fields:
    tblContacts tblUpdate
    ID1 ID2
    FirstName FName
    LastName LName
    Address Address
    E-mail Email

    The two tables are not related. I want to update tblContacts.E-mail with tblUpdate.Email for the same last name. For starters I created a two-table Select Query and joined them on LastName-LName. When I switch to Datasheet View I get a useless error message that simply informed me that the query failed, with no reason given. I've created lots of queries of all types in my time, but I'm stumped by this one. What am I missing?
    HH

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    Do you have a unique index on lastname in both tables?

    Can you post a demo database, so we can look at the problem? Just the two tables with a few records, and the query you have attempted.
    Regards
    John



Posting Permissions

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