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 <*> 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/
