Does anyone know if it is possible via Query to group results by Week when
the field actually
contains a full date?
I have a query where I have to pull all data and the SUM of a field which
all should be grouped
by Week such as:
Week 1 (01/01/2006 - 01/07/2006)
John Smith
Project 5: 15hrs
Project 6: 10hrs
Week 2 (01/08/2006 - 01/15/2006)
John Smith
Project 5: 12hrs
Project 6: 19hrs
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240869
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
