need help make a report

  • Thread starter Thread starter redburns
  • Start date Start date
R

redburns

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.
 
message
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.
Click to expand...
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.
 
Back
Top