Date Filter Access Macro

[FSCK!]

Hello All -

I have a db with a drop down field which automatically runs a
predefined macro based on the folowing selections:

"All";"Today";"This Week";"Last Week";"This Month";"Last Month";

I have added an additional selection with corresponding macro for "This
Year" as follows:

(Year([Opened Date])=Year(Date()) And Year([Opened Date])=Year(Date()))

My problem is, I am now trying to add an addional entry named "Last
Year" and I am having trouble. Here is how I am doing it:

(Year([Opened Date])=Year(Date()) And Year([Opened
Date])=(Year(Date())-1))

Could someone be so kind as to tell me what I am doing wrong with the
above? To test this, I set my clock ahead one year and was expecting
the macro to show me inputs for 2006, however, nothing shows.

Many thanks in advance

 

[Steve Schapel]

FSCK,

I do not understand why the Criteria is being repeated twice.
(Year([Opened Date])=Year(Date()) And Year([Opened Date])=Year(Date()))
is equivalent to simply...
Year([Opened Date])=Year(Date())

As for the "last year" criteria, this doesn't work.
(Year([Opened Date])=Year(Date()) And Year([Opened Date])=(Year(Date())-1))
is saying the opened date is both this year and last year at the same
time, which is impossible for a date to simultaneously be in two
different years. Try it just like this...
Year([Opened Date])=Year(Date())-1

By the way, this doesn't appear to have anything to do with macros.

 

[FSCK!]

many thanks Steve, this worked wonderfully. I am still learning this,
so I thank you for your insight.

FSCK,

I do not understand why the Criteria is being repeated twice.
(Year([Opened Date])=Year(Date()) And Year([Opened Date])=Year(Date()))
is equivalent to simply...
Year([Opened Date])=Year(Date())

As for the "last year" criteria, this doesn't work.
(Year([Opened Date])=Year(Date()) And Year([Opened Date])=(Year(Date())-1))
is saying the opened date is both this year and last year at the same
time, which is impossible for a date to simultaneously be in two
different years. Try it just like this...
Year([Opened Date])=Year(Date())-1

By the way, this doesn't appear to have anything to do with macros.

--
Steve Schapel, Microsoft Access MVP

Hello All -

I have a db with a drop down field which automatically runs a
predefined macro based on the folowing selections:

"All";"Today";"This Week";"Last Week";"This Month";"Last Month";

I have added an additional selection with corresponding macro for "This
Year" as follows:

(Year([Opened Date])=Year(Date()) And Year([Opened Date])=Year(Date()))

My problem is, I am now trying to add an addional entry named "Last
Year" and I am having trouble. Here is how I am doing it:

(Year([Opened Date])=Year(Date()) And Year([Opened
Date])=(Year(Date())-1))

Could someone be so kind as to tell me what I am doing wrong with the
above? To test this, I set my clock ahead one year and was expecting
the macro to show me inputs for 2006, however, nothing shows.

Many thanks in advance