Member Avatar for devilz

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

  • 1 Contributor
  • 1 Reply
  • 142 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by devilz
Member Avatar for devilz

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.