How to merge 2 reports into one

C

Candy

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
 
S

SA

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.
 
F

FatiHAN

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

"Candy":
 
C

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...
 
D

Duane Hookom

I think "merge" is "union" and "interrogation" is "query". Therefore
consider doing as Steve suggests.
 
Top