[AccessD] (no subject)

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
> 
>