search for old reports

  • Thread starter Thread starter Sarah
  • Start date Start date
S

Sarah

Hi, I am writing a new database for my manager and have just done courses
etc, and really dont know what i am doing. What i am trying to do is, i have
written tables, forms and reports. now i have have a report that i have
added subreports to, and i am trying to save the reports in the database, so
that my manager can go back through the quotes and see the records of what he
has charged previously. But i really dont know where to begin. Could you
please help? Thanks
 
Reports are layouts that use the data. As the data changes so does the
information displayed in a report.

If you need to save the displayed information, you can "print" the information
to a pdf file and archive it off.

On the other hand if you just need to regenerate the report information, you
would filter the records for the report.

For instance, if you were looking at information on expenses, you would have
expense charge records with a date that the expense was incurred. Then the
report would show expenses for a time period (say Sept 1 to Sept 30 2009) and
the report would use that criteria to display the information for that time
period. Now, if in November you added a record for an overlooked expense in
September then the output of the report would be changed. In that case, you
might need to record the date of entry along with the date of expense if you
wanted to know what the report looked like as of September 30.


John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
Hi John,

Thanks for that, My manager would like the report to be put into like an
archive area, where he can go and look if he ever needs to. What i am trying
to do is, i have written a quoting system for our department, and with that i
have all different tables for example, one is the contractor's wage's per
hour another is the consumables we need to use etc, i have linked all of
these together and then at the end it give's me a report of how much the job
will cost. I need to have a record of all job's quoted so we can go back and
find out if we have gone over budget etc. i think there is away that you can
save it into your database? I have figured out how to make it come up with a
new record (as per reading all the help on this website) but just need a copy
of what has been done. Even if i can get the system to save it in excel
file? I have figured out how to export (but it looks really bad), i would
like the system to automatically save "somewhere" so that all my boss has to
do is push a button. Thanks Sarah
 
Back
Top