Summing two different queries in a Crosstab

[shaleen7]

I have two queries with different criteria but the data is coming from the same tables. I want to combine the data results in a crosstab query.

Criteria one:
not ({ZIP} in ["08824", "98236"]) and
not ({STATE} in ["NY", "NJ"]) and
not isnull({DELIVERYDATE}) and not isnull ({companyorderDATE})


Criteria TWO:
not ({ZIP} in ["53336", "98236"]) and
not ({STATE} in ["NY", "NJ"]) and
isnull({customerDELIVERYDATE})and isnull({companyorderDATE})

I already have a running total set up in a crosstab using criteria 1. I want to add the results of Criteria TWO.
Is this possible?

 

[mulchman]

Hello

Your Question:
have two queries with different criteria but the data is coming from the same tables. I want to combine the data results in a crosstab query.

My Response:
I find CrossTabs very limiting so I do all my work in the SQL. As a result, redo your 2 SQL Queries by combining them into one Query by using either a UNION or a SubQuery with the main Query.