John, Here are the actual tables & fields. The ones with ASTERISK are common fields to both. What we want is to bring data from TblDowngrades inot SANDER table. They are numerically matched so you can see which ones are "common". Data type is NUMBER on all except the Date & ID.
SANDER TABLE ID 1-DATE 2-SHIFT DTHOURS OPHOURS 3-THICK CODE 4-WIDTH 5-LENGTH INPCS 6-CSPCS 7-RSPCS 8-SHPCS 9-RJPCS TblDowngrades TABLE ID 1-SandDate 2-SandShift Lot # 3-Thick 4-Width 5-Length 6-CriticalSurface 7-RegularStock 8-B-Grade 9-Reject Blows RejBrokenPanels ShpBrokenPanels Fissures SanderKO Pits SandThrough SanderSetUp Spots RejThkVar ShpThkVar Warp ShpMisc RejMisc --- In [email protected], "John Viescas" <[EMAIL PROTECTED]> wrote: > Greg- > > You still haven't told me what's *really* in these tables. You have implied > that the rows match on "Y" values, but now you tell me there are multiple > "Y's". I can come up with a simple solution if there's a unique way to > match the rows in the two tables. On ID? On some set of columns? Need > more info... > > 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 2:32 PM > > To: [email protected] > > Subject: [ms_access] Re: Merge Tables & Data? > > > > > > > > In reality there are many "Y"'s, multiple fields that are common > > to both tables. Then in the case of the fields that are not in > > the one we're importing to we want to bring in those fields too. > > > > I guess there is no "merge" table function anywhere? Maybe > > we can start there. Or a work around for such? > > > > Thanks, > > Greg > > > > > > --- In [email protected], "John Viescas" <[EMAIL PROTECTED]> wrote: > > > 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 > > > > > > > > > > > > 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/
