Hey Again
I have this query now:
Delete * FROM final where Vaccination <> 'BCG' or Vaccination <> 'BCG & POLIO' or Vaccination <> 'Booster DPT & Polio' or Vaccination <> 'Booster DT & Polio' or vaccination<>'Booster Hepatitis B' or vaccination <>'CHICKENPOX VACCINE' or vaccination <>'DPT' or vaccination<>'DPT 1 & POLIO' or vaccination<>'DPT 2 & POLIO' or vaccination<>'DPT 3 & POLIO' or vaccination<>'DT & POLIO 1' or vaccination<>'DT & POLIO 2' or or vaccination<>'DT & POLIO 3' or vaccination<>'H.I.B.1' or vaccination<>'H.I.B.2' or vaccination<>'H.I.B.3' or vaccination <>'H.I.B.Booster' or vaccination<>'Hepatitis A 1' or vaccination<>'Hepatitis A 2' or vaccination<>'Hepatitis A 3' or vaccination<>'Hepatitis B 1' or vaccination<>'Hepatitis B 2' or vaccination<>'Hepatitis B 3' or vaccination<> 'Hepatitis B Booster' or vaccination<>'M.M.R.' or vaccination<>'Measles' or vaccination<>'Meningococal A+C' or vaccination<>'Polio' or vaccination<>'Rabies Vaccine' or vaccination<>'T.T' or vaccination<>'Typhi' or vaccination <>'Yellow Fever'
When I run this query it deletes everything form the field Vaccination.