Access Reports

  • Thread starter Thread starter Sglian
  • Start date Start date
S

Sglian

Hey,

I was wondering if it would be possible to run a report
for a list distribution. I am horrible at explaining
things so please bare with me.

Each week I send a Medical Alert out to different
departments in my hospital. However, the departments that
I send the alert to each week change. So what I would like
to do is make a standard report layout (meaning ~ The
design of how I want the report to look like) and than
where I can select the departments I want to send it to.
And change the dates on the report. Is that actually
possible? That way i wouldnt have to type the data in
there week after week. Please let me know if you guys have
better suggestoins or need more info on what I am talking
about.

Sarah
 
Create a query with the information you want. Put in
[enter Dept:] in Critia in the query, under department
field. Under date field critia -Between [enter begining
date:] And [enter end date:] Create the report from the
query. When you run the report you will be asked for
dept and date. Hope this helps
 
A well-designed Access application should produce the reports in the way as
you desired: the user (i.e. you) are given a form that allows you select
some information you want to put onto the report: department, data.... After
your selection, a simple button click should send the report to, either a
printer, a fax machine, or email... It also can be scheduled to generate
these report automatically with proper information on it.

If you have to type data repeatedly, week after week, for the same report,
then get someone who knows how to set up/program MS Access to help you. If
you know a bit more technically and post here some code/macro you are using,
someone here may give more detailed solutions.
 
Back
Top