If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
need help make a report
Every week we run a report that tells us the non-
subscribers list by zip and route. In this report is the zip code, District, route number and the count, fields or "in layman terms the number of non-subscribers". Then on Monday the District managers hands in a written report on the route, they checked, "not all route are check. " They divided the District into four areas and check four different routes every week. This report has the zip code and route numbers that are checked. Let's call the first report TMC and the second one weekly reports (Verification). It takes me one hour and 45 min to do these reports. This is my idea: To input both reports into the access program. The TMC report comes across in Excel program and I would input the other one weekly. Then find the one that matches the zip code and route number that match. Then from the TMC report total all the non-subscribers count total from the TMC report. Then because all the routes have a total count, add the ones that print out. And add the zip code and routes in the zip code. Example of print out: Zip code ALL Routes in that zip code, that match Sub-totals of non-subscribers/ count in that zip code Grand total of all the non-subscribers in the TMC report and the Grand total of non-subscribers/ count in that zip code and give me a per cent. If you can get me start and possible send me, your idea. I would appreciate. |
#2
|
|||
|
|||
need help make a report
" wrote in message ... snip It takes me one hour and 45 min to do these reports. This is my idea: To input both reports into the access program. The TMC report comes across in Excel program and I would input the other one weekly. Then find the one that matches the zip code and route number that match. Then from the TMC report total all the non-subscribers count total from the TMC report. Then because all the routes have a total count, add the ones that print out. And add the zip code and routes in the zip code. If you can get me start and possible send me, your idea. I would appreciate. Importing or linking to the Excel report is easy and if Excel is not being used as a word processor to get a pretty report the data might be valid. How long does it take you to enter the hand coded data into *any* Access form or table? If the TMC information is valid and it does not take you an hour and 45 minutes to enter the data then you should be able to proceed and most of what you want to do would be handled by reports. So to get you started 1. Can Access actually speed up the process? 2. If yes design link to the Excel report, add the tables you need, and design a form for input. 3. Design your reports using queries. 4. Read help. 5. Read help. 6. Ask questions not answered by reading help in the appropriate group. |
#3
|
|||
|
|||
need help make a report
right I do it on paper. By look the route and zip code up
on the TMC report! -----Original Message----- " wrote in message ... snip It takes me one hour and 45 min to do these reports. This is my idea: To input both reports into the access program. The TMC report comes across in Excel program and I would input the other one weekly. Then find the one that matches the zip code and route number that match. Then from the TMC report total all the non-subscribers count total from the TMC report. Then because all the routes have a total count, add the ones that print out. And add the zip code and routes in the zip code. If you can get me start and possible send me, your idea. I would appreciate. Importing or linking to the Excel report is easy and if Excel is not being used as a word processor to get a pretty report the data might be valid. How long does it take you to enter the hand coded data into *any* Access form or table? If the TMC information is valid and it does not take you an hour and 45 minutes to enter the data then you should be able to proceed and most of what you want to do would be handled by reports. So to get you started 1. Can Access actually speed up the process? 2. If yes design link to the Excel report, add the tables you need, and design a form for input. 3. Design your reports using queries. 4. Read help. 5. Read help. 6. Ask questions not answered by reading help in the appropriate group. . |
Thread Tools | |
Display Modes | |
|
|