Tiers

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!!
 
If the tiers are consistent in their pattern and don't need frequent
adjusting, you might consider using the Partition() function.
 
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.
 
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)
 
Back
Top