Recent content by cannonej76

I went about it from a different angle and it works perfectly. Thank you for mentioning Partition in your response. I searched for some articles on Partition and Frequency Distribution. I thought about and started from scratch. A combination of IIF and Partition does the trick. Range...

thank for the reply... I am not familiar with writing functions... any help is greatly appreciated!

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]...