I have a table that holds data for each month in a separate field - month01, month02, month03 etc.
I want the user to be able to select the appropriate month from a pick list and then run an sql which picks the correct field for that month and displays the data in it.
I am not sure how to format the sql based on the above selection.
Can anyone help? I can configure the sql to filter the data but not the field name!
3 Nov, 2009 - 01:40 AM
| 
