Tiers

[Guest]

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!!

 

[Duane Hookom]

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

 

[Guest]

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.

 

[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)