[AccessD] (no subject)

Thank you, Patricia.  that worked.  Now, how do I get it to give me the Name of the month instead of the number?


> You can use the MONTH function or Datepart function to determine month
> 
> > TRANSFORM Count(tlnkFoodEvent.GuestsPerType) AS CountOfGuestsPerType 
> > SELECT tblEvent.Weekend 
> > FROM tblEvent INNER JOIN tlnkFoodEvent ON tblEvent.InvoiceNo = 
> > tlnkFoodEvent.EventID 
> > GROUP BY tblEvent.Weekend 
> 
> > PIVOT MONTH(tlnkFoodEvent.FoodSvsDate);
> OR
> > PIVOT DatePart("m",tlnkFoodEvent.FoodSvsDate);
> 
> HTH
> 
> ******************************************************************
> *Patricia O'Connor
> *Associate Computer Programmer Analyst
> *OTDA - BDMA
> *(W) mailto:Patricia.O'Connor at dfa.state.ny.us
> *(w) mailto:aa1160 at dfa.state.ny.us
> ******************************************************************
>  
> 
> > -----Original Message-----
> > From: accessd-bounces at databaseadvisors.com 
> > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> > ksklos at comcast.net
> > Sent: Tuesday, June 15, 2004 08:53 PM
> > To: accessd at databaseadvisors.com
> > Subject: [AccessD] (no subject)
> > 
> > I have several tables which I need to pull into a monthly 
> > summary report.  I am using a crosstab query to pull in the 
> > information but I can not get it to summarize by month.  Can 
> > any one help.  Here is what I have so far:
> > 
> > TRANSFORM Count(tlnkFoodEvent.GuestsPerType) AS 
> > CountOfGuestsPerType SELECT tblEvent.Weekend FROM tblEvent 
> > INNER JOIN tlnkFoodEvent ON tblEvent.InvoiceNo = 
> > tlnkFoodEvent.EventID GROUP BY tblEvent.Weekend PIVOT 
> > tlnkFoodEvent.FoodSvsDate;
> > 
> > --
> > _______________________________________________
> > 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