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
Is there a trick to cause empty columns to show in the query results?
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
got it...thanks Cap
see this thread
https://www.experts-exchange.com/questions/21638202/Crosstab-Query-Pivot-Values.html