Medical field report problem

[Steve]

-- Hello:
I am having a little problem with ACCESS 2007 and I hope someone can help.
I’m new with Access 07 so I’m hoping that I just did something wrong that is
easy to remedy.
Here is a little history on my database project…I work at a very small
medical facility and I am trying to use Access to keep track of information
on our residents and also use the database to print up month long medication
sheets that we could use to sign off meds as they are given. I constructed
the DB’s to include all pertinent information that we would require. I also
created a report that I hoped would show each individual resident’s
information (D.O.B., Allergies, locations, Medications, etc.)
Now for the problem I am having: When I go to “PRINT PREVIEW†all of the
information is in the correct positions on the report BUT it will show one
residents name with someone else’s list of medications on the report. I
can’t seem to get only one person’s information on the report preview. I have
tried grouping and sorting in every way that I can think of-but still can’t
get my reports to be individualized amongst the residents.
I hope someone can give me a suggestion to remedy my problem.
Steve

 

[Russell]

Steve,



Do you want to only produce a report for an individual patient or a group of
patients?


Also just make sure that you research your responsibilities to holding and
using medical data for clinical decisions etc without an audit trail.

 

[Steve]

What I am attempting to do is keep a DB of all pertinent info (DOB,
allergies, prescribed medications) on our work computer for all our residents
so that we can use it to print up Med. Sheets, Clinic visit assessment forms,
ect…basically use the information so that the staff could use the computer to
print up forms (reports) as we need them.
What I have been trying to work on first was a report that would print up a
single med sheet for each resident listing all of their meds on a single
individual page (or multiple pages depending on the amount of meds a resident
is on at the time). I have the report set up as a 8.5X11 landscape with
various info at the top (report header) and the bottom (page footer) and the
center (detail section) should contain a list of seven meds and all of their
related data (dosage, route, start/stop dates etc) I have the report set up
the way we need it with all the information where it should be. But when I
go to “Print Preview†I keep getting meds of different residents mixed
together.
Like I said before, I am an ACCESS newbie and I am really stumped on what I
am doing wrong. If you have any further questions about my quandary, please
ask, as I would really like to get this straightened out.
**And before you ask….no, our “IT†guys have been of no help.

Steve