[AccessD] Partition

Try it on a DOB column:

TRANSFORM Count(CInt(DateDiff("yyyy",[date of birth],Now()))) AS CountOfAge
SELECT CInt(DateDiff("yyyy",nz([date of birth],Now()),Now())) AS [Years Old]
FROM DOB
GROUP BY CInt(DateDiff("yyyy",nz([date of birth],Now()),Now()))
PIVOT Partition(CInt(DateDiff("yyyy",nz([date of 
birth],Now()),Now())),0,99,10);

-
Michael R Mattys
MapPoint and Database Dev
www.mattysconsulting.com
-
----- Original Message ----- 
From: "Mike Mattys" <mmattys at rochester.rr.com>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Thursday, August 06, 2009 11:12 PM
Subject: Re: [AccessD] Partition


> Zero to one hundred in columns of ten?
> Is there a sale on yarn coming up?
>
> -
> Michael R Mattys
> MapPoint and Database Dev
> www.mattysconsulting.com
> -
> ----- Original Message ----- 
> From: "Stuart McLachlan" <stuart at lexacorp.com.pg>
> To: "Access Developers discussion and problem solving"
> <accessd at databaseadvisors.com>
> Sent: Thursday, August 06, 2009 11:05 PM
> Subject: [AccessD] Partition
>
>
>> Quick VBA quiz:
>>
>> What does this return and why?
>> (Actually runnning it to find out is cheating!)
>>
>> Partition(99.5,0,100,10)
>>
>>
>> -- 
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>