Query Criteria Problem

[kopy]

I have 2 fields Year and Month. They are both numeric and in YYYY and MM formats.
I’m trying to write a query that will select records that are less than the current date.

For Year I’m using <=Year(Date()).
For Month I’m using <Month(Date()).

Because we are in Feb, I’m only selecting records for Jan.

How would I change the Month criteria to select records like 11 or 12 for months from the previous year?

Thank you in advance for your help,
Kopy

 

[Andrzejek]

select records like 11 or 12 for months from the previous year

[tt]
Select *
From SomeTable
Where fldYear < Year(Date())
And fldMonth Between 11 And 12
[/tt]


---- Andy

There is a great need for a sarcasm font.

 

[combo]

Add field in a query: (12*[Year]+[Month]) and criteria <(12*Year(Date()+Month(Date())

combo

 

[dhookom]

I would try combine the fields.

Are your field names actually Year and Month? These are names of function (reserved words).

WHERE YearField * 100 + MonthField < Year(Date()) * 100 + Month(Date())

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016