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

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Apply a year filter    
 
   
lentin
post Oct 21 2004, 10:00 AM
Post #1

UtterAccess Member
Posts: 30
From: Chatham, Kent, UK
Is it possible for me to use a drop down box [getyear] with a list/value of 2004;2005;2006 etc to filter records by year on a form by [arrival_date]. arrival_date uses short date format.

I have tried DatePart(yyyy,[arrival_date]= [geyear] on "On Change" but I get the error message that the formula is too complex.

Any help would be appreciated
Go to the top of the page
 
+
AJS
post Oct 21 2004, 10:07 AM
Post #2

UtterAccess VIP
Posts: 3,893
From: Lansing, Michigan, USA
Try
Year([Arrival_Date]) = [getyear]

-AJ
Go to the top of the page
 
+
lentin
post Oct 21 2004, 11:52 AM
Post #3

UtterAccess Member
Posts: 30
From: Chatham, Kent, UK
Tried that but it then comes up wanting parameter values for [arrival_date] and then [get_year]. So I then tried using a command btn and putting your expression on on-click and it still asks for the parameter values, but thanks for trying AJ
Go to the top of the page
 
+
Kellif
post Oct 22 2004, 04:36 PM
Post #4

UtterAccess Addict
Posts: 141
I would try tying the combo box to an aggregate (i.e. sum) query with the same data source as that the form is on; but where there is just one field - a calculated expression for the year (i.e. get_year: DatePart("yyyy",[arrival_date]) and no other data fields.
Go to the top of the page
 
+
« Next Oldest · Access Macros · 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: 24th May 2013 - 07:37 PM