Determining which vaccine was given in a date range

Tech-Archive recommends: Fix windows errors by optimizing your registry

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


.