Partition function in Access
Once I found that Access has Partition function, which I never used. Function returns a Variant (String) indicating where a number occurs within a calculated series of ranges. You can use is to find lower and upper edge of partition where number falls. Few samples:
Now I am thinking – how can I use it? Looks like I never missed such function. Do you have real-life example using Partition function?