Hello,
I have a number of Access reports (see [login to view URL] in the attached file) which I wish to generate as a pivot table (to obtain the flexibility of pivot tables). The reports are based on queries which I wish to reuse for the Pivot Tables, but I am not sure if I can carry out calculations similar to what I do in the reports to calculate the Abs Change and % Change. I am also unsure if the Pivot Table can be formatted in a manner similar to the report. As well, the data is dynamic, users specify the years when they are running the calculation.
For an idea of what the Pivot Table currently looks like, see [login to view URL] in the attached file.
I therefore require:
1. Pivot tables which produce Abs Change, %change and Total calculations like [login to view URL]
2. The ability to specify the years for running the query.
3. Formatting to produce an attractive report.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
Ms Access 2002, SQL Server 2000