Re: [MS_AccessPros] Update Query not performing as expected

 

Jan-

It looks like that should work unless IDENTIFICATION_NUMBER contains something you don't expect.  Switch to SQL view in your query and post the text you see - that's much more precise than trying to visualize what you see on the query design grid.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

SQL Queries for Mere Mortals 

http://www.viescas.com/ 

(Paris, France)

On Mar 26, 2015, at 5:30 PM, jan.hertzsch@gmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

I am creating an update query comparing four fields on two tables. When I have a match, I want to update a fifth field in the receiving table with an Identification number from the primary table. It appears to be matching properly but the identification number field in the receiving field is being populated by the last name data from the sending field.

My joins are as follows:

Registered_Voter_Table                     Patrons_Table

Last Name                                            Last Name                       

First Name                                            First Name

House Number                                     House Number

Street Name                                         Street Name

My update command is

Field: IDENTIFICATION_NUMBER

Table: PATRONS_TABLE

Update to: [REGISTERED_VOTER_TABLE].[IDENTIFICATION_NUMBER]

Criteria: Blank

What am I doing wrong?  Thanks

__._,_.___

---

Posted by: John Viescas <johnv@msn.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___