Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Easy one I'm sure and I think I need to use the class function but just to check
I have a Straight table of data and i need a banding column, The column I need banded is Project Period with values of 0 up to 96. I need these banded in 0<10, 10<20, 20<30 etc.
Should i use the class function
If your intervals are all the same then the class function is the easiest way to create the bands: class([Project Period],10)
If your intervals are all the same then the class function is the easiest way to create the bands: class([Project Period],10)
What if the intervals are different. For example. I have a field that i want to count and put into bandings of - 1,2,3,4,5,6,7, 8-14, 15-21, 22-28, 29 days - 6 months, 6 months - 12 months and > 12 Months
Kev
You can use a largish nested if statement or create another table with the intervals and use the intervalmatch function to match the intervals to your period values.