Simple query

  • Thread starter Thread starter an
  • Start date Start date
A

an

I have:

SELECT Table1.Param, Table1.Date, Table1.Val, *
FROM Table1
WHERE (((Table1.Date) Like "??*" & [Choose number month]
& "??*"));

The date has Medium Date format in Table1 and Query.
(01-Jan-04)
The query work fine, except to month 2.
Why?

I would like to have possibility to choose year too.
How, please

Thanks in advance.
an
 
Like really doesn't work very well with dates or numbers, because it is designed
to work with text. I would suggest that the easiest solution (not the most
efficient) would be to use the Month and Year functions.

SELECT Table1.*
FROM Table1
WHERE Month(Table1.[Date])= [Enter number month] AND
Year(Table1.[Date])= [Enter Year as 4 digits]
 
Exactly!
Many thanks for your help.
Have you a good weekend.
an
-----Original Message-----
Like really doesn't work very well with dates or numbers, because it is designed
to work with text. I would suggest that the easiest solution (not the most
efficient) would be to use the Month and Year functions.

SELECT Table1.*
FROM Table1
WHERE Month(Table1.[Date])= [Enter number month] AND
Year(Table1.[Date])= [Enter Year as 4 digits]


I have:

SELECT Table1.Param, Table1.Date, Table1.Val, *
FROM Table1
WHERE (((Table1.Date) Like "??*" & [Choose number month]
& "??*"));

The date has Medium Date format in Table1 and Query.
(01-Jan-04)
The query work fine, except to month 2.
Why?

I would like to have possibility to choose year too.
How, please

Thanks in advance.
an
Click to expand...
.
Click to expand...
 
Back
Top