Patient Location

[LMB]

I am using Acess 2003 for the first time. I have been using Access 2000. I
have a List of patients admitted to the hospital on therapy. I need to have
their location based on Area, Room Number and Bed Number. This also will
tie in with therapy type because I need to know where the patient was
located when they were on ventilator therapy. They may have been in area
MSICU, Room 121 bed 1 while they were getting vent therapy. Now they may be
in area 1B, Room 121, bed 2 but they are on Aerosol and MDI therapy. Should
I put the PtLocID in my tblPatients? As you can see I am getting myself
mixed up. I probably need to give more info but I can't think of what so
here is a start.

Here are some of my tables.

tblAreasList
AreaID
AreaDesc

tblBedList
BedListID
BedNumber

tblPtLoc
PtLocID
PtID_fk from tblPatients
AreaID_fk from tblAreas
BedListID_fk from tbl Beds
RoomNum

tblPatients
Patient ID
LName
FName
Etc

tblPtThpy
PtThpyID
PtID_fk from tblPatients
ThpyTypeID_fk from tblTherapyType
ThpyStartDtTm
ThpyEndDtTm
Etc

Thanks,
Linda

 

[Kevin Jameson]

you cant do this with microsoft access 2003

you must upgrade to access 20004 by clicking here:
http://www.ammara.com/access_image_faq/access_loading_image_dialog.html

HTH

Kevin

 

[LMB]

I don't have the option to upgrade. I would need a solution that could be
acomplished in Access 2003.

Linda

 

[Duane Hookom]

Ignore the reply from Kevin Jameson. It is SPAM and has no meaning to you or
anyone else.

I would add a from and to date/time to the patient location table.
LocStartDtTm
LocEndDtTm

 

[LMB]

Ahhh about Kevin, I thought that was kind of weird. I didn't click the link
so that's good, probably a site wouldn't want to look at.

I figured out to add the date after I made a form and looked at it. Will I
be able to link the date somehow later to show what type of therapy was done
at that location? I am still getting myself mixed up because I don't have a
record made for each day, in all my tables it's a date range and I think I
am normalizing the data so far.

At least I have a form and a subform now.

Linda

 

[Duane Hookom]

You should be able to create a query to find the location at the point in
time of the Therapy.