Tiers

M

Mike C

I used to know how to do this :( I have a query that shows sales for our
accounts. I'd like to be able to group the accounts in tiers e.g. all
accounts that sold between 0 and 5 dollars grouped together, followed by 5.1
to 10, 10.1 to 15 etc. My fields are AccountID, Sales. Any help would be
great. Thanks!!
 
D

Duane Hookom

If the tiers are consistent in their pattern and don't need frequent
adjusting, you might consider using the Partition() function.
 
M

Mike C

Duane,

Thanks! That did it. You bring up a good point. I haven't crossed that
bridge yet but I think I could do it using a second table that defines the
non-standard tiers and a SQL join on the range of values in the second table.
Thanks for the help. Much appreciated.
 
V

Van T. Dinh

Check Access VB Help on the Switch() function where you can create the
"TierNo" depending on the Sales value.

--
HTH
Van T. Dinh
MVP (Access)
 
Top