I have looked at your sample database, and I'm still befuddled. GroupName
in TempFamilyAddress appears to contain a number, not a name. Is this
related to GrpID or SubGrpID? Do you want to insert rows into GrpMembers?
Please clarify.
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)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of ghsclass65
Sent: Saturday, June 29, 2013 6:58 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] update query help
I've got three tables that are related... OrgSub, TempFamilyAddress, and
GrpMembers.
I want to update the field SubGrpID in the GrpMembers table with the value
in table OrgSub field SubGrpID.
The field SubGrpName corresponds to the GroupName field in the table
TempFamilyAddress and the SubGrpID Name value should be filled according to
that value of GroupName in TempFamilyAddress.
They should be linked by Household #. See the sample db I've uploaded
called SampleUpdateSubGrpID.
------------------------------------
Yahoo! Groups Links
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar