Search results

I am trying to segment customer into ranges of amounts purchased. When I use the switch function, Access tells me it is too complex. I believe there is a limit of 7 and I need 18. Here was my formula that was too complex. 2011_Status: Switch([2011] = 0,1,[2011] Between 0 And 5000,2,[2011]...