Get a count of headers (fields) in the Select statement of a crosstab query

[rcovington]

Is there a way to get a count of the headers (fields) that occur only in the Select statement of a crosstab query? I can get the ordinal position and name of each field in a crosstab query, yet it will be better to get a count of those fields that occur only in the Select statement.

 

[arnelgp]

You just create a query that counts it:

Selec count(*) from (select distinct columnfield From yourtable)

 

[rcovington]

Thanks for your quick reply arnelgp. I'm more than likely missing something about the element columnfield?

 

[arnelgp]

If you exam the xtsb in sql there is a portion there, Pivot. That field i am referring.

 

[rcovington]

Thank you again arnelgp. That now gives me a count of the columns (fields) in the pivot clause.