Array output to a Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've got an array that collects the Grade, Division and JobTitle from a
recordset. I would like to output this to a table in the following format:
(Anyone got any ideas?)

Array Jobs()

Grade Division JobTitle
21 Credit Collections Manager
21 Sales Sales Manager
21 Credit Accts Payable Manager
21 Credit Accts Receivable Manager
21 Sales Advertising Manager
21 Finance Sr Financial Analyst
20 Sales Advertising Asst
20 Credit Account Representative
20 Sales Sales Representative
20 Finance Financial Analyst


This is how I would like the Output table to look like.

Grade Credit Finance Sales
21 Collections Manager Sr Financial Analyst Sales Manager
Accts Payable Manager Advertising Manager
Accts Receivable Manager
20 Account Representative Financial Analyst Advertising Asst
Sales Representative
 
Sorry the format didn't not remain for the table

I wish to display:

Grade Div1 Div2 Div3 Div4
18 Jobtitle Jobtitle Jobtitle Jobtitle
Jobtitle Jobtitle Jobtitle Jobtitle
17 Jobtitle Jobtitle Jobtitle Jobtitle
Jobtitle Jobtitle Jobtitle Jobtitle
 
Let me further explain:
I wish to display in the first column the grade,
then horizonatally display each division, divname1 divname2 divname3 etc
under each division display the jobtitle.
Ex: under Sales at grade 21 would be Sales Mgr and Advertising Mgr
Some divisions may not have a jobtitle in that grade and a null value is okay.
 
I'm sure this can be done with SQL, but it's not straightforward. So
I've crossposted this message to the Queries newsgroup where the experts
hang out: look out for replies there.

If there's no joy from the SQL wizards, it's possible but tedious to do
it in VBA.

One relevant question: are the number and names of the divisions fixed
for all time, or are they liable to change?
 
Back
Top