Determining which vaccine was given in a date range

[Mark S]

I am using access 2002. I have a table that lists a patients age, name and
the dates a number of vaccines were given like
Name
Birthdate
Vaccine1Number1Date
Vaccine1Number2Date
Vaccine1Number3Date

I need to determine if a vaccine needs to be given knowing that at 2 months
you can give Vaccine1Number1 and that the next dose (Vaccine1Number2) is not
given for another two months etc. Then give me a number predictor per month
about which vaccines are due. I am not sure where to begin. Any
suggestions?
*****************************************
Mark M Simonian MD FAAP

 

[Guest]

I think your table is laid out wrong. Use this as table structure.
tblPatient --
PatientID - Autonumber - primary key
LName - text
FName - text
MI - text
Sex - text
DOB - DateTime

tblVaccines --
VaccineID - Autonumber - primary key
Vaccine - text
AgeGiven - number - Age in months
Follows - number - foreign key of VaccineID
FollowMonths - number

tblVaccinations --
VaccinationID - Autonumber - primary key
PatientID - number - foreign key
VaccineID - number - foreign key
VaccinationDate - DateTime
Age - number - Age vaccination given in months

Your queries would use DateDiff("m", Date(), DOB or VaccinationDate and
months criteria from last or related Vaccination.