Show all records in crosstab query

[Stacey]

I have a query built on two crosstab queries. The linked field is Processor. The data in the first crosstab query contains 3 processors that are different than in the second crosstab query. The second contains processors that aren't in the first. What my ultimate objective is is to have a report that prints the data from both queries. But any way I set the linking properties on the query, it leaves out some of my data, because the processor fields don't match exactly. When I change the link to the Date field, it brings back 522 records, when there are only 26 records. (it's duplicating records).

Please help! I don't know how to fix this.

Thanks
Stacey

 

[jmersing]

You say that have joined the queries on the Processor field, but then you also say they do not match eachother. How can they be joined if they do not match?


What you may want to try is using group headers in a report for both processor fields. This may separate the grouping to where both processor groups are listed. Just select the the grouping option on Report design view and choose Headers on for both.

If this does not help maybe you could post your SQL
Jim