Ah, but the common field is "Y", and it isn't necessarily unique? Please see my earlier response and answer the questions I posed there.
John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ > -----Original Message----- > From: [email protected] > [mailto:[EMAIL PROTECTED] On Behalf Of Greg Saucier > Sent: Tuesday, May 03, 2005 1:47 PM > To: [email protected] > Subject: [ms_access] Re: Merge Tables & Data? > > > > I'm sorry John, yes there is a field in both tables called "ID" in > Autonumber format that is set as primary key. > > Greg > > > --- In [email protected], "Greg Saucier" <[EMAIL PROTECTED]> wrote: > > > > No, there is no primary key in either table, just some > > common fields to both tables. > > > > Greg > > > > --- In [email protected], "John Viescas" <[EMAIL PROTECTED]> wrote: > > > Greg- > > > > > > Does either table have a Primary Key? Field Y? > > > > > > John Viescas, author > > > "Building Microsoft Access Applications" > > > "Microsoft Office Access 2003 Inside Out" > > > "Running Microsoft Access 2000" > > > "SQL Queries for Mere Mortals" > > > http://www.viescas.com/ > > > > > > > -----Original Message----- > > > > From: [email protected] > > > > [mailto:[EMAIL PROTECTED] On Behalf Of Greg Saucier > > > > Sent: Tuesday, May 03, 2005 11:50 AM > > > > To: [email protected] > > > > Subject: [ms_access] Re: Merge Tables & Data? > > > > > > > > > > > > Hi John, > > > > > > > > Thanks so much for the help. > > > > > > > > Yes the two tables have duplicate data, but not in every field. > > > > There are field differences in the two tables and I am trying > to > > > > merge them together. > > > > > > > > In Table A for example I have field X & Y but not Z. > > > > I guess we are wanting to reconcile the records in each table > > > > and merge them into one, thus eliminating the dups and ALSO > > > > bringing the field data over that is not there now. > > > > > > > > If you could imagine a way to bring in an entire FIELD from > > > > one table into another that is what we are trying to achieve. > > > > > > > > Hope that helps. > > > > > > > > Greg > > > > > > > > --- In [email protected], "John Viescas" <[EMAIL PROTECTED]> > > wrote: > > > > > Greg- > > > > > > > > > > Please explain what you mean by "there are duplicates." Do > you > > > > want to > > > > > eliminate the duplicates? Also are there rows in Table A or > > Table > > > > B that do > > > > > not have a matching Y value in the other table? > > > > > > > > > > Answer these questions, and I can write the appropriate SQL > for > > you > > > > to get > > > > > the job done. > > > > > > > > > > John Viescas, author > > > > > "Building Microsoft Access Applications" > > > > > "Microsoft Office Access 2003 Inside Out" > > > > > "Running Microsoft Access 2000" > > > > > "SQL Queries for Mere Mortals" > > > > > http://www.viescas.com/ > > > > > > > > > > > -----Original Message----- > > > > > > From: [email protected] > > > > > > [mailto:[EMAIL PROTECTED] On Behalf Of Greg Saucier > > > > > > Sent: Tuesday, May 03, 2005 9:04 AM > > > > > > To: [email protected] > > > > > > Subject: [ms_access] Merge Tables & Data? > > > > > > > > > > > > > > > > > > > > > > > > Hi, > > > > > > > > > > > > Can someone help me figure out if its possible to > > > > > > merge two tables together into one while maintaining > > > > > > existing data? > > > > > > > > > > > > For example, Table A has fields X & Y and Table B > > > > > > has fields Y & Z. I want to make a new table (or query) > with > > > > > > X, Y & Z and have all the records match (there are > > > > > > duplicates) when I am done. > > > > > > > > > > > > Thanks > > > > > > Greg > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Yahoo! Groups Links > > > > > > Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> 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/
