I have an access database that calculates data from several tables, based on criteria selected in FORM (parameters)
which allows you to select from 2 different reports (classnbr) and (twp report)...
What I am wanting to find out is if there is a way I can save the data from certain reports of my choosing (not all are good)
I am looking at the color coded lines in the reports mostly...
Is there a way to save some of the data from reports of my choosing?
The data i would like to save includes TOWNSHIP, CLASS, NBRHD, # SALES, MEAN, MEDIAN, COD, PRD, TRENDING FACTOR.
I think that is all, but I am sure if these can be saved, it is possible to add or delete a couple more
I want to save data to access table, or excel, I really dont care, whichever is easier, is this even possible to do in this database?? it has been worked on by several people, and is getting very complicated to work on, without messing up another function of some kind..
I am thinking maybe some button back on form parameters, so that after i get the report the way i want it, by selecting different parameters, i can close report and click on a SAVE DATA button..
let me clarify better,....
i run hundreds of these reports in a day, normally i sit here with paper and pencil and write the rusults of the calculations from the reports, (the ones i want) in a blank spreadsheet .. then i have to go back and enter them into an excel spreadsheet, i am wanting the select data items enterd into a table or excel automatically when i get the report right..
so in the end i will have a table or excel with just the data i want , not just the data from 1 report but from possibly hundreds of reports
sampl data for form parameters
class 500
grade aaa - e-1
## 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 web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) 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).
* * *This broadcast message was sent to all bidders on Thursday Feb 23, 2006 5:29:11 PM:
let me clarify better,....
i run hundreds of these reports in a day, normally i sit here with paper and pencil and write the rusults of the calculations from the reports, (the ones i want) in a blank spreadsheet .. then i have to go back and enter them into an excel spreadsheet, i am wanting the select data items enterd into a table or excel automatically when i get the report right..
so in the end i will have a table or excel with just the data i want , not just the data from 1 report but from possibly hundreds of reports
sample data for form parameters
class 500
grade aaa - e-1
## Platform
windows xp