Hi I have a table with 12 "expiry date: columns for different tickets. How can I do a query that would select all the expiry date columns that would include all dates less than today and also include 90 days in the future. I can't use multiple ANDS or OR's any suggestions? The following is my query as it goes through the query as I add and statements there is no data. The first statement after where brings back 50 rows if I add the second it then drops to 10 and so on.........hopefully this makes sense. SELECT users.lname, users.fname, users.positionappfor, users.hdsaliveexp, users.firstaidexp, users.fallproexp, users.whimisexo, users.regrescueexp, users.pitsexp, users.defdriveexp, users.otherexp, users.bopexp, users.boilerexp, users.confinedexp, users.loaderforkliftexp, users.jpickerboomerexp, users.boplineexp, users.tdgexp, users.detflameexp, users.driveexpire, users.driversabstract, users.drivedemerit FROM users WHERE (users.hdsaliveexp < date_sub(now(), interval -90 day)) AND (users.firstaidexp < date_sub(now(), interval -90 day)) AND (users.fallproexp < date_sub(now(), interval -90 day)) AND (users.whimisexo < date_sub(now(), interval -90 day)) AND (users.regrescueexp < date_sub(now(), interval -90 day)) AND (users.pitsexp < date_sub(now(), interval -90 day)) AND (users.defdriveexp < date_sub(now(), interval -90 day)) AND (users.otherexp < date_sub(now(), interval -90 day)) AND (users.bopexp < date_sub(now(), interval -90 day)) AND (users.boilerexp < date_sub(now(), interval -90 day)) AND (users.confinedexp < date_sub(now(), interval -90 day)) AND (users.loaderforkliftexp < date_sub(now(), interval -90 day)) AND (users.jpickerboomerexp < date_sub(now(), interval -90 day)) AND (users.boplineexp < date_sub(now(), interval -90 day)) AND (users.tdgexp < date_sub(now(), interval -90 day))