How to merge 2 reports into one

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

Guest

Hi, there,
I want to merge 2 similar structured reports into one. Both report have a
field called 'JobNo' and a pivot format of convert dates to weekdays. How do
I merge the reports in to a format like this:
JobNo Monday Tuesday Wednesday Thursday Friday
11111 data from report 1------------------------------
11111 data from reort 2 ------------------------------
22222 data from report 1------------------------------
22222 data from reort 2 ------------------------------
Any tip will be appreciated.

Candy
 
Candy:

Use what is called a Union query from the two existing report's underlying
queries to create a query that combines the data for your new report. In a
union query, the two (or more) underlying queries must have the same number
of columns (fields), but it look like that's exactly what your queries would
have.
 
hello Candy,I bad speak English. Manage Pleace.
Now,you must merge it's interrogation to merge different report.

"Candy":
 
Sorry, I don't understand what you mean:(

FatiHAN said:
hello Candy,I bad speak English. Manage Pleace.
Now,you must merge it's interrogation to merge different report.

"Candy":
Click to expand...
 
I think "merge" is "union" and "interrogation" is "query". Therefore
consider doing as Steve suggests.
 
Back
Top