Stuart McLachlan
stuart at lexacorp.com.pg
Wed Jun 16 20:47:37 CDT 2004
On 17 Jun 2004 at 1:40, ksklos at comcast.net wrote:
> Thank you, Patricia. that worked. Now, how do I get it to give me the Name of the month instead of the number?
>
.....
> >
> > > PIVOT MONTH(tlnkFoodEvent.FoodSvsDate);
> > OR
> > > PIVOT DatePart("m",tlnkFoodEvent.FoodSvsDate);
> >
Either
MonthName(MONTH(tlnkFoodEvent.FoodSvsDate))
or
Format(tlnkFoodEvent.FoodSvsDate,"mmmm")
--
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System Support.