Heenan, Lambert
Lambert.Heenan at AIG.com
Tue Nov 14 15:34:21 CST 2006
There's also the Switch function which allows you to group by ranges, like this... Data Range: Switch([SomeDataValue]>8,"a) > 8",[SomeDataValue]>=5,"b) >= 5 and <= 8",[SomeDataValue]>=2,"c) >= 2 and < 5",[SomeDataValue]<2,"d) < 2") In effect Switch is like "convoluted IIF statements", but without the convolutions! :-) Note that the order of the various comparisons in the statement is significant as Switch stops at the first condition that evaluates to True. An advantage over Partition is that you can define the groupings arbitrarily instead of them being equal groups of size "interval". Lambert -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte Sent: Tuesday, November 14, 2006 1:50 PM To: accessd at databaseadvisors.com Subject: Re: [AccessD] FW: Partition Function Thanks Rocky... I do a lot of age grouping on age of cases. This beats the heck out of the convoluted IIF statements I've been using. Thanks, Mark A. Matte >From: "Beach Access Software" <bchacc at san.rr.com> >Reply-To: Access Developers discussion and problem >solving<accessd at databaseadvisors.com> >To: "'Access Developers discussion and problem >solving'"<accessd at databaseadvisors.com> >Subject: Re: [AccessD] FW: Partition Function >Date: Tue, 14 Nov 2006 10:12:50 -0800 > >Well, that didn't forward very well. Here's a link to the MSDN page >describing it: > >http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbenlr >98/ht >ml/vafctpartition.asp > > >Rocky > > >-----Original Message----- >From: accessd-bounces at databaseadvisors.com >[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Beach Access >Software >Sent: Tuesday, November 14, 2006 9:47 AM >To: 'Access Developers discussion and problem solving' >Subject: [AccessD] FW: Partition Function > >Dear List: > > > >FYI. From another developer. > > > >Rocky > > > > > > _____ > >From: joe anderson [mailto:jka at alldatacorp.com] >Sent: Monday, November 13, 2006 9:55 AM >To: Subject: Partition Function > > > >Well ... here is a VBA function that I've never seen in 14 years!! >Looks like it could be pretty useful!!! It's not even in Getz's book >... at least not in the index at the back! > > > >I found it in a cool little book Titled "Fixing Access Annyoances' ... >a$20 book that has already paid for itself! By .. Phil Mitchell and >Evan Callahan. > > > >jka > > >" :-1" > >" 0: 4" > >" 95: 99" > >" 100: " > > >20 > >199 > >10 > >" : 19" > >" 20: 29" > >" 190: 199" > >" 200: " > > >100 > >1010 > >20 > >" : 99" > >" 100: 119" > >" 1000: 1010" > >" 1011: " > > > >In the table shown above, the third line shows the result when start >and stop define a set of numbers that can't be evenly divided by >interval. The last range extends to stop (11 numbers) even though >interval is 20. > >If necessary, Partition returns a range with enough leading spaces so >that there are the same number of characters to the left and right of >the colon as there are characters in stop, plus one. This ensures that >if you use Partition with other numbers, the resulting text will be >handled properly during any subsequent sort operation. > >If interval is 1, the range is number:number, regardless of the start >and stop arguments. For example, if interval is 1, number is 100 and >stop is 1000, Partition returns " 100: 100". > >If any of the parts is Null <javascript:hhobj_5.Click()> , Partition >returns >a Null. > > >-- >No virus found in this incoming message. >Checked by AVG Free Edition. >Version: 7.5.430 / Virus Database: 268.14.3/531 - Release Date: >11/12/2006 7:34 PM > > >-- >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com > >-- >No virus found in this incoming message. >Checked by AVG Free Edition. >Version: 7.5.430 / Virus Database: 268.14.5/533 - Release Date: >11/13/2006 8:56 PM > > >-- >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com _________________________________________________________________ Try the next generation of search with Windows Live Search today! http://imagine-windowslive.com/minisites/searchlaunch/?locale=en-us&source=h mtagline -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com