Search results

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

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

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.

I'm from a small town in Georgia of the USA, semi retired from a school system, and have just a small bit of experience with building little Access apps that other users can use to process and output records into easy to read reports or Excel files.