Help...Merging 2 reports with 1 field that contains data that matc Dacid D. Vanderpool 17.08.2006 14:29:01 Help Please..........I need to build a report that contains names, social security numbers and other data. I need to marry two different data tables (each table contains names, social security numbers, etc.). into one report that I can see what names and other data is in the final report. There are other things I need tthe report to do but I can make Access to those things.

RE: Help...Merging 2 reports with 1 field that contains data that matc td 18.08.2006 16:57:02 Hello Dacid Why do you have multiple tables containing the same type of data? Anyway... Yes! You can use a report based on a UNION. However, there is a problem in that the fields for each part of the Union must parallel each other eg SELECT Fld1,Fld2,Fld3 FROM tblA UNION SELECT FldA,FldB,FldC FROM tblB The field counts in each SELECT must match and the corresponding fields must be of the same type of data. Hope this helps td "Dacid D. Vanderpool" wrote: [Quoted Text] > Help Please..........I need to build a report that contains names, social > security numbers and other data. I need to marry two different data tables > (each table contains names, social security numbers, etc.). into one report > that I can see what names and other data is in the final report. There are > other things I need tthe report to do but I can make Access to those things.

RE: Help...Merging 2 reports with 1 field that contains data that Dacid D. Vanderpool 18.08.2006 17:27:02 That helps a lot............ Thank you. Dave "td" wrote: [Quoted Text] > Hello Dacid > Why do you have multiple tables containing the same type of data? > Anyway... > Yes! You can use a report based on a UNION. However, there is a problem in > that the fields for each part of the Union must parallel each other eg > SELECT Fld1,Fld2,Fld3 FROM tblA > UNION > SELECT FldA,FldB,FldC FROM tblB > The field counts in each SELECT must match and the corresponding fields must > be of the same type of data. > Hope this helps > td > > "Dacid D. Vanderpool" wrote: > > > Help Please..........I need to build a report that contains names, social > > security numbers and other data. I need to marry two different data tables > > (each table contains names, social security numbers, etc.). into one report > > that I can see what names and other data is in the final report. There are > > other things I need tthe report to do but I can make Access to those things.