Group By

[njws]

I have a field FiscalMonths which are in the range 1 - 12. The goal is to be able to have the user enter either a single period (5 for example) or a range (10-12) and have it return the sum of a Sales column.

My problem is two-fold. I don't know how to do the user prompt and if I set the criteria for 10 - 12, I get all of 10, then all of 11, then all of 12.

Thank you for your help!

 

[Norie]

Try setting criteria like this for FiscalMonths

Between [Please enter start Month] And [Please enter end Month]

 

[njws]

That still has all of month 10, then all of 11, then all of 12. I want it to group those fiscal months together.

 

[Royal Presence]

I would set it by quarter then. Then they can choose 1,2,3, or 4th quarter.