I trying to solve for data having multiple values in one given year. The data/table is as follows...I have years 2000-2016 and say they're for store credit. So each person or account has one record associated with it and they all have that group of years 2000-2016. I have a multi select box on my user form that has all the years and an "All" selection. When the user holds control+click they can select multiple years and that is passed to the query criteria via VBA. In order to provide the year for the query to find I have a formula in a base query that says (see below) and that allows me to pull records for a given persons year, however when someone has credit it both 2001 and 2001 or 2001,2002,2003 the formula only gives a value of 2001, the first instance it's found. This causes the query results to be incorrect because if I query 2002, 2003, 2004 then I lose the record that had a person in 2002 and 2001 because they aren't satisfying the criteria 2002.

AnyYearCredit: IIf((([2004]>0)),"2004",IIf((([2005]>0)),"2005",IIf((([2006]>0)),"2006",IIf((([2007]>0)),"2007",IIf((([2008]>0)),"2008",IIf((([2009]>0)),"2009",IIf((([2010]>0)),"2010",IIf((([2011]>0)),"2011",IIf((([2012]>0)),"2012",IIf((([2013]>0)),"2013",IIf((([2014]>0)),"2014",IIf((([2015]>0)),"2015",IIf((([2016]>0)),"2016","False")))))))))))))

So what I need is a way ideally with VBA where a user can select multiple years from a selection box and the query looks at fields [2001],[2002]...[2016] for values > 0

Thanks!!