Hi,
Can someone explain how I can update one table with another tables data
using critera?
Here is what I have:
Had Db with one table split the table so client data is on a new table
(CLIENTOINFO), created a "clientId" field on old table(DATATABLE)
I assume I can use an update query to assign the "ID" on [CLIENTINFO]
TO "clientid" ON [DATA]?
What I don'yt know is how to specify the critera, matching up last
name, first name and DOB on each table?
Thanks in Advance
Joe
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
