Dear reader (s),

In my AccessDB, JanuaryDay(Table) having two columns JanDate & JanShift. JanDate contains all the dates of each month and JanShift contains text value for each date. Its like:

Id JanDate JanShift
1 1/1/09 SM
2 1/2/09 M
………………………
………………………
31 1/31/09 M

I Can retrieve the recordset for a specific month which I want to display in MsFLGrid. I Want the JanDate value as column name of MsFLGrid and JanShift will display in next row of MsFLGrid. Output will be:

1/1/09 1/2/09 ……………… 1/31/09
SM M M

Can any one please help me with some sample VB6.o code???

Regards

Dear reader (s),

In my AccessDB, JanuaryDay(Table) having two columns JanDate & JanShift. JanDate contains all the dates of each month and JanShift contains text value for each date. Its like:

Id....... JanDate..........JanShift
1..........1/1/09..............SM
2..........1/2/09.............. M

........................................
........................................

31.......1/31/09..............M

I Can retrieve the recordset for a specific month which I want to display in MsFLGrid. I Want the JanDate value as column name of MsFLGrid and JanShift will display in next row of MsFLGrid. Output will be:

1/1/09..1/2/09.................1/31/09
SM........ M.......................M

Can any one please help me with some sample VB6.o code???

Regards

This article has been dead for over six months. Start a new discussion instead.