SELECT Individual.Name, Individual.Rank, Individual.Flight, Individual.Anthrax, DateAdd("yyyy",10,[Yellow Fever Taken]) AS [Yellow Fever], DateAdd("yyyy",10,[Tetanus Diptheria Taken]) AS [Tetanus Diptheria], DateAdd("m",6,[Yellow Fever Taken]) AS [Hepatitis A], DateAdd("d",180,[Hepatitis B Taken]) AS [Hepatitis B], DateAdd("yyyy",2,[Typhoid Taken]) AS Typhoid, DateAdd("yyyy",1,[Influenza Taken]) AS Influenza, DateAdd("yyyy",5,[Menomune Taken]) AS Menomune, DateAdd("yyyy",1,[TB Skin Test Taken]) AS [TB Skin Test], DateAdd("yyyy",0,[Polio Taken]) AS Polio, DateAdd("yyyy",10,[Smallpox Taken]) AS Smallpox, Individual.[Measles, Mumps, and Rubella Taken]
FROM Individual
WHERE (((Individual.Anthrax) Between Date() And Date()+30)) OR (((DateAdd("yyyy",10,[Yellow Fever Taken])) Between Date() And Date()+30)) OR (((DateAdd("yyyy",10,[Tetanus Diptheria Taken])) Between Date() And Date()+30)) OR (((DateAdd("m",6,[Yellow Fever Taken])) Between Date() And Date()+30)) OR (((DateAdd("d",180,[Hepatitis B Taken])) Between Date() And Date()+30)) OR (((DateAdd("yyyy",2,[Typhoid Taken])) Between Date() And Date()+30)) OR (((DateAdd("yyyy",1,[Influenza Taken])) Between Date() And Date()+30)) OR (((DateAdd("yyyy",5,[Menomune Taken])) Between Date() And Date()+30)) OR (((DateAdd("yyyy",1,[TB Skin Test Taken])) Between Date() And Date()+30)) OR (((DateAdd("yyyy",10,[Smallpox Taken])) Between Date() And Date()+30));