This may be a simple query but I would appreciate any help possible.

I have a query that I would like to selct only dates in a certai
month. I know how to use a form to enter start dates and end dates an
then select the date field between 'start date' and 'end date'. Howeve
I would like the user to simply enter in a three letter code for th
month and the query to select all records within that month.

eg. entering 'jan' will select all dates between 1/1 and 31/1 of jan o
the current year.

Is this easy to do?

Thanks in advance

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

On Mon, 16 Feb 2004 05:54:51 -0600, SlySi
<(E-Mail Removed)> wrote:

>
>This may be a simple query but I would appreciate any help possible.
>
>I have a query that I would like to selct only dates in a certain
>month. I know how to use a form to enter start dates and end dates and
>then select the date field between 'start date' and 'end date'. However
>I would like the user to simply enter in a three letter code for the
>month and the query to select all records within that month.
>
>eg. entering 'jan' will select all dates between 1/1 and 31/1 of jan of
>the current year.
>
>Is this easy to do?

Not too hard: a criterion of

>= CDate("1-" & [Enter month:] & "-" & Year(Date()) AND < DateAdd("m", 1, CDate("1-" & [Enter month:] & "-" & Year(Date()))

will do the trick. If your users can enter month numbers it's a bit
simpler using DateSerial():

>= DateSerial(Year(Date()), [Enter month number:], 1) AND < DateSerial(Year(Date()), [Enter month number:] + 1, 1)


John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public

You can also try

SELECT * FROM [your table name]
WHERE FORMAT([your date field],"mmm") = [given month]
"SlySi" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> This may be a simple query but I would appreciate any help possible.
>
> I have a query that I would like to selct only dates in a certain
> month. I know how to use a form to enter start dates and end dates and
> then select the date field between 'start date' and 'end date'. However
> I would like the user to simply enter in a three letter code for the
> month and the query to select all records within that month.
>
> eg. entering 'jan' will select all dates between 1/1 and 31/1 of jan of
> the current year.
>
> Is this easy to do?
>
> Thanks in advance.
>
>
> ------------------------------------------------
> ~~ Message posted from http://www.ExcelTip.com/
> ~~View and post usenet messages directly from http://www.ExcelForum.com/
>