[AccessD] (no subject)

No, from the date.  In other words, all dates that fall within a certain month, I want them grouped together within that month.


> You want it to determine the month from Weekend? 
> 
> Susan H. 
> 
> 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