I have a typical issue and couldn't find any post in the community already answering this:
I need to create a calendar based on selections done in 3 Listboxes --> Code, Year and Month (this has a list of working and non-working days in the form of 0's and 1's).
I have loaded this table of data(as above) pertaining to these fields--Code,Year and all the months as Fields (Jan,Feb ...Dec). Every month having the values in the form of 0's and 1's representing non working days(0's) and working days(1's). I need to create a table as an output which can show up by clicking a button (after selection made from Code,Year) and must contain
Code
Year
Month
Date
Working/Non-Working Day
01
2014
01
01/01/2015
0
01
2014
01
02/01/2015
1
01
2014
01
03/01/2015
1
I have framed the question in the best of language I could hope to get some solution from the experts.