UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Weekly Report    
 
   
kmatt318
post Dec 15 2008, 02:47 PM
Post #1

UtterAccess Enthusiast
Posts: 61
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?
Go to the top of the page
 
+
theDBguy
post Dec 15 2008, 03:36 PM
Post #2

Access Wiki and Forums Moderator
Posts: 48,021
From: SoCal, USA
Hi,

You can group your data using an expression like:

WorkWeek: Format([WorkDate], "ww")

(untested)
Hope that helps...
Go to the top of the page
 
+
kmatt318
post Dec 15 2008, 04:09 PM
Post #3

UtterAccess Enthusiast
Posts: 61
thanks, I will let you know.
Go to the top of the page
 
+
theDBguy
post Dec 15 2008, 04:39 PM
Post #4

Access Wiki and Forums Moderator
Posts: 48,021
From: SoCal, USA
You're welcome and good luck.
Go to the top of the page
 
+
« Next Oldest · Access Queries · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 23rd May 2013 - 12:46 AM