Crosstab - Add rows and columns seperately

[Andrew6464]

Hi,

I'm trying to see if there is a way of adding the data for both the rows and columns in different queries

The SQL query has three columns  - location name, location type and size of location.

The location name will be the row header and location type is a column

I need to display all location names which may not have a location type. Currently this creates a null column and and I haven't found a way of hiding it.

If I filter out nulls in my query, it then excludes location names with no type but as I have said, I need to show all location names

Is there any way I can run one query which will output all location names with a type and then run another query to add the remaining location names