Link to home
Start Free TrialLog in
Avatar of OnsiteSupport
OnsiteSupport

asked on

Forcing Crosstab Query to show columns with no data

I'm using a crosstab query to flip data sideways.  But, if a field has no data, then the crosstab doesn't show the "empty" column.

Is there a trick to cause empty columns to show in the query results?

Thanks
ASKER CERTIFIED SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
if you have a fixed column names, you can create a table for the column names and use it to produce the empty columns...

see this thread

https://www.experts-exchange.com/questions/21638202/Crosstab-Query-Pivot-Values.html
Avatar of OnsiteSupport
OnsiteSupport

ASKER

got it...thanks Cap