Help...Merging 2 reports with 1 field that contains data that matc

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
That helps a lot............ Thank you. Dave

td said:
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
Click to expand...
 
Back
Top