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

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Date Question    
 
   
rfikes
post Feb 28 2006, 05:25 PM
Post #1

UtterAccess Addict
Posts: 108
Running a date query that groups items by Quarter. What do I need to put in the criteria part to tell it to only run for 2005 or 2006, etc.

My Quarter field is: WeekEnding By Quarter: Format$([Time Cards].[WeekEnding],'\Qq yyyy')


Thanks!

Edited by: rfikes on Tue Feb 28 17:40:39 EST 2006.
Go to the top of the page
 
+
Larry Larsen
post Feb 28 2006, 05:42 PM
Post #2

UA Editor + Utterly Certified
Posts: 22,722
From: Melton Mowbray,Leicestershire (U.K)
Hi
Create a new query grid column and place your field [WeekEnding] which will be converted to reflect the year and set your criteria for this column to =2005
eg:

Year Selected: Year([WeekEnding]) << This should just display/extract the year value..
.............
Criteria >> =2005

HTH's
(IMG:http://www.utteraccess.com/forum/style_emoticons/default/thumbup.gif)
Go to the top of the page
 
+
rfikes
post Feb 28 2006, 05:46 PM
Post #3

UtterAccess Addict
Posts: 108
Thanks!

That did what I needed.
Go to the top of the page
 
+
Larry Larsen
post Feb 28 2006, 05:50 PM
Post #4

UA Editor + Utterly Certified
Posts: 22,722
From: Melton Mowbray,Leicestershire (U.K)
(IMG:http://www.utteraccess.com/forum/style_emoticons/default/yayhandclap.gif) (IMG:http://www.utteraccess.com/forum/style_emoticons/default/thumbup.gif)
You're welcome..
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:09 AM