kmatt318
Dec 15 2008, 02:47 PM
I am trying to create a query that groups by work week but all my date fields are by ##/##/#### formats. Is there an easy way to do this?
theDBguy
Dec 15 2008, 03:36 PM
Hi,
You can group your data using an expression like:
WorkWeek: Format([WorkDate], "ww")
(untested)
Hope that helps...
kmatt318
Dec 15 2008, 04:09 PM
thanks, I will let you know.
theDBguy
Dec 15 2008, 04:39 PM
You're welcome and good luck.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please
click here.