gdanalakshmi
Registered User.
- Local time
- Today, 14:06
- Joined
- Nov 26, 2002
- Messages
- 102
I am trying to feed a crosstab's query outpout into a listbox.
But my column count will differ according to the query result since it is a crosstab query.
How do i find the column name of the crosstab query in VBA??
For Example if my crosstab result is like the following with 5 columns.
Name TotalOfHelpDesk Newchurn Voice StandardCancel
Then my listbox should display all the 5 columns.
Suppose my query output is 6 columns, then i should display the 6 columns, But how do I know the field name like Name, NewChurn,Voice, StandardCancel etc. Is there any function to get the fieldname?
But my column count will differ according to the query result since it is a crosstab query.
How do i find the column name of the crosstab query in VBA??
For Example if my crosstab result is like the following with 5 columns.
Name TotalOfHelpDesk Newchurn Voice StandardCancel
Then my listbox should display all the 5 columns.
Suppose my query output is 6 columns, then i should display the 6 columns, But how do I know the field name like Name, NewChurn,Voice, StandardCancel etc. Is there any function to get the fieldname?