Even Better I took data from all 3 and dumped them into one table. Now I need to Crosstab as such:

Dealer District ...

Here are the 3 tables I am using. Is this what you're looking for? Is there no easy way to "union all" all 3 tables, make a derived table from...

Here are the 3 tables I am using. Is this what you're looking for? Is there no easy way to "union all" all 3 tables, make a derived table from...

Here is my code:

select *

from

(select [Ship To Dealer],[Status],[Car Line]

from [Dlr Inventory]

WHERE [Dlr Inventory].[Ship To Dealer]<>'020177' and [Dlr Inventory].von is not null and [Dlr Inventory].[Delivery Date] is null

union all

select [Ship To...

OK so my answer is cross tab it, but I am still lost. This example uses sum and I need to use count so I am thrown. Would you be...