pmullarkey
New Member
- Joined
- Feb 4, 2005
- Messages
- 1
Hi all,
I'm trying to do something a bit complex and am a little stuck and hoping for some assistance.
I have suceessfully created a pivot table which connects via odbc to an oracle database. So far so good....
A couple of the fields being returned from the oracle db are just inter values such a 1, 2 or 3. Each value corresonds to an appropriate description. For example I know that 1=good 2=bad 3=ok etc etc.
I am trying to figure out is there anyway to create a look up or reference table or something similar (or maybe VB macro) which will convert the display in the pivot table from the integer value to the descriptive value......and I haven't the faintest clue how to progress!
So any ideas or help you could give me would be greatly appriciated.
thank in advance!
I'm trying to do something a bit complex and am a little stuck and hoping for some assistance.
I have suceessfully created a pivot table which connects via odbc to an oracle database. So far so good....
A couple of the fields being returned from the oracle db are just inter values such a 1, 2 or 3. Each value corresonds to an appropriate description. For example I know that 1=good 2=bad 3=ok etc etc.
I am trying to figure out is there anyway to create a look up or reference table or something similar (or maybe VB macro) which will convert the display in the pivot table from the integer value to the descriptive value......and I haven't the faintest clue how to progress!
So any ideas or help you could give me would be greatly appriciated.
thank in advance!
