R
Rich Gillett
Firstly, thanks for your help! We're working with some doctors at an NHS
hospital in the UK to work out (1) what percentage of patients go for an scan
after their first appiontment, and (2) what percentage go from a follow up
appointment. We only need to do this as a one-off.
The data comes from 2 different databases as a CSV, which is loaded into
Access 2007 as two different tables. The first table comes from the
appointment system, the second table
The first database is the appointment system, which has the fields:
PatientID, the date of the appointment, the specialism of the doctor and
whether or not the appointment was the first appointment or a follow-up.
The second table comes from the scaning/MR/x-ray system and has the fields;
PatientID, date referral received (from the specialist doctor in the first
database), the type of scan, and then the date the appointment took place.
The scanning table will have a referral from the doctor a day or two after
the appointment, but it may vary between the same day, and maybe up to 4 days
later.
What we need to work out is which scans came from which appointments.
What's the best way to do this?
If I've missed any inforamtion out, please let me know, it's my first post
ever. Really grateful for your help,
Rich
hospital in the UK to work out (1) what percentage of patients go for an scan
after their first appiontment, and (2) what percentage go from a follow up
appointment. We only need to do this as a one-off.
The data comes from 2 different databases as a CSV, which is loaded into
Access 2007 as two different tables. The first table comes from the
appointment system, the second table
The first database is the appointment system, which has the fields:
PatientID, the date of the appointment, the specialism of the doctor and
whether or not the appointment was the first appointment or a follow-up.
The second table comes from the scaning/MR/x-ray system and has the fields;
PatientID, date referral received (from the specialist doctor in the first
database), the type of scan, and then the date the appointment took place.
The scanning table will have a referral from the doctor a day or two after
the appointment, but it may vary between the same day, and maybe up to 4 days
later.
What we need to work out is which scans came from which appointments.
What's the best way to do this?
If I've missed any inforamtion out, please let me know, it's my first post
ever. Really grateful for your help,
Rich