Re: Query on Month

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Rick B (anonymous_at_discussions.microsoft.com)
Date: 07/02/04 

Date: Fri, 2 Jul 2004 09:05:40 -0500

If you want the whole month spelled out (harder for your users) You could
use the following...

Words: Format(DatePart("m",[dateassigned]),"mmmm")

If you wanted the user to type in just a portion of the month, like Janu for
january or Jan, or Ja, etc. you could put the folloing in the criteria...

like [Enter month]&"*"

Rick B

"CG" <anonymous@discussions.microsoft.com> wrote in message
news:2538601c4603b$1010a600$a501280a@phx.gbl...
I want to query my database to find all employees born in
a particular month, regardless of year. How do I write
this?

I would like to be able to type into a parameter
box "july" and it find everyone who was born in July.

Thanks!
CM

Relevant Pages

  • Re: Query on Month
    ... I want to query my database to find all employees born in ... a particular month, regardless of year. ...
    (microsoft.public.access.queries)
  • Query on Month
    ... I want to query my database to find all employees born in ... a particular month, regardless of year. ...
    (microsoft.public.access.queries)
  • Re: Query of three fields simultaneously
    ... Storing multiple values in a single field (regardless of whether ... database normalization rules. ... to choose the keywords associated to each book. ... until this: I want to create a query that ...
    (microsoft.public.access.forms)
  • Re: AJAX, XML and Caching(?)
    ... or not the database was changed in the meantime. ... if it was changed you make a new query, regardless how many requests are ... The read-actions can then still use a static XML-file ...
    (comp.lang.javascript)
  • Re: Query on Month
    ... You would need to add a new column to your query to pull the month out of ... their birthdate. ... I want to query my database to find all employees born in ...
    (microsoft.public.access.queries)