Hello, I have a query in which one two tables with different fields using a person identifier. Among the certain fields I have two with the purchase amounts and in the query I include an expression that divides both amounts and returns the%. The problem is that once I have the percentages I would like to group them with a table of percentages (0 - 10 - 25 - 50 -...) to the clients so that if a client has a percentage of 37% for example it would be grouped with those of 50%. That is to say, to group the amounts by taking out their totals, so that if a record does not belong to the prefixed% it must be grouped with the immediately superior one.
Thanks in advance