home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.lang.visual.basic      MS Visual Basic discussions, NOT dot-net      10,840 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 10,013 of 10,840   
   Joe-Paul to All   
   CrossTab Query   
   14 Apr 06 20:59:57   
   
   From: HarvestWind@comcast.net   
      
   Hi:   
      
   I'm using a "CrossTab" Query to retrieve data.  When I get it back, I want   
   to print the column Headers along the first row of the grid.  How to I get   
   the names of the column Headers?  The names of the columns will be dynamic;   
   i.e., I am listing facilities and getting total transports provided for each   
   facility. I am returning the Name of the Facility (or it's designator) as   
   Column headers and want that in the first row...with the totals in the   
   second row.  Is there a way to use visual basic and get the names of the   
   columns in the Crosstab...and then put each one in a field in the first row?   
      
   Your advice would be appreicated.   
      
   JP   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca