I need Help on Array and I am Very poor coding on array
I have a table which contains custcode,mthcode,model,Interest,carnode.
It is suppose to display in report like this:-
custcode mthcode model interest carnode
C00001 B1 3000 40 SW11
C00001 B2 4000 45 SE12
C00001 B3 5000 50 SWQ2
C00001 B4 6000 55 FE53
C00001 B5 7000 60 GT66
But I want to display in report like this:-
Custcode : C00001
Mthcode B1 B2 B3 B4 B5
Model 3000 4000 5000 6000 7000
Interest 40 45 50 55 60
Carnode SW11 SE12 SWQ2 FE53 GT66
I believe that Array can help on this, Anyone Can help me on this report and coding. I tried to use crosstab But It fail.
I appreciated if you can provide me a code. Thanks.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only