Create a range of values from a numeric field in a summary report
I have a db related to my anesthetic procedures. I would like to create a summary report and some charts from this summary in which I could compare two fields from my databank: body mas index (BMI) X consumption of specific anesthetic drug. However, both fields are numeric fields and it would be better if I could group them in some ranges of values (BMI: 20-24,99; 25-29,99; 30-34,99; 35-39,99... and consumption of anesthetic drugs: up to 200 mg; up to 400 mg; up to 600 mg.......)
I don't know how to set the summary report to group these numeric values in ranges.
I would like to thank in advance for your attention.
Ricardo Vieira Carlos