Re: Query on Month

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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

Date: Fri, 2 Jul 2004 09:03:52 -0500

Note: If you would really like to use the month in words, you could do the
following...

MonthOfBirth: Format(DatePart("m",[Birthdate]),"mmm")

Then in the criteria...

[Enter month (Jan=January, Feb=February, etc.)]

"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 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: 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: 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)
  • 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: DBMS and lisp, etc.
    ... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database. ... (eq (order-customer orderA) ...
    (comp.lang.lisp)