How to merge 2 reports into one

[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

 

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

 

[Guest]

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

"Candy":

 

[Guest]

Sorry, I don't understand what you mean

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

"Candy":

 

[Duane Hookom]

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

 

[Guest]

Thanks, guys, I've made it working by union 2 crosstab queries.