http://blogs.msdn.com/access/archive/2009/07/02/group-numbers-into-custom-ranges.aspxI was looking at SQM data about file size last week and ran into an interesting question. We capture the size of the file every time Access opens the file in SQM. It is interesting data as it provides insights into the size of a typical existing app.en-USCommunityServer 2.1 SP1 (Build: 61025.2)http://blogs.msdn.com/access/archive/2009/07/02/group-numbers-into-custom-ranges.aspx#9816604Fri, 03 Jul 2009 13:10:36 GMT91d46819-8472-40ad-a661-2c78acb4018c:9816604Garry Robinson<p>I wrote a similar article that uses IIF functions here</p> <p><a rel="nofollow" target="_new" href="http://www.vb123.com.au/toolbox/06_access/trickyqueries.htm">http://www.vb123.com.au/toolbox/06_access/trickyqueries.htm</a></p> <p>Garry Robinson</p> http://blogs.msdn.com/access/archive/2009/07/02/group-numbers-into-custom-ranges.aspx#9816942Fri, 03 Jul 2009 20:59:11 GMT91d46819-8472-40ad-a661-2c78acb4018c:9816942Tony Toews [MVP]<p>I wonder what the performance would be like if you indexed the MinSize and Maxsize fields. &nbsp;Then try indexing the SizeOfFileKb field. &nbsp; </p> <p>Just for the fun of it.</p> <p>I had to do a query about ten or thirteen years ago on double fields which were in a Cartesion join. &nbsp; It was trying to locate all the places on a 1000 mile long pipeline where both cracks and corrosion were within a few metres of each other. &nbsp; Indexing the location, which was a double field, used in the Between dropped the query from 25 minutes to 25 seconds.</p> http://blogs.msdn.com/access/archive/2009/07/02/group-numbers-into-custom-ranges.aspx#9824397Wed, 08 Jul 2009 20:37:24 GMT91d46819-8472-40ad-a661-2c78acb4018c:9824397Mike Alexander<p>Why not use the PARTITION function?</p>