I have an annual revenue report that i want to show in my database (ADP).
The report shows revenue that is produced for different things over the last 12 months, it is broken up in to month views. We recieve this report at random intervals. The report would then be imported to an SQL table called tbl_revenue.
What i want to be able to do is to have 12 text boxes in a form, these will then show information from the tbl_revenue table, so the last 12 months that we have available. However as it can change i want the lables on the fields to change as they can always change.
In the table the Column headings are as follows.
xxx-07 xxx-07 eg jan-07 feb-07 then jan-08 feb-08 as we get new reports for 2008.
I want the form to take the month and the year and rename the label January 2007 or January 2008 etc.
I then need the corresponding text box to show the correct column. so the 1st text box will always show the 1st month, the 7th will always show the 7th month. These wont always be January or July, it could be any month depending on which month the report start withs.
The columns run in order of the oldest to newest month.
If this explanation isnt good enough please let me know and i will try to elaborate more.
Start Free Trial
