Results 1 to 2 of 2

Thread: Quickie

  1. #1
    Join Date
    Sep 2003

    Question Unanswered: Quickie

    I have a date field with entries in dd/mm/yyyy format.

    What i would like is to create a parameter query which picks out all records for a specific month.

    How do I get the parameter to just look at the month when querying?

    Does this make sense?

  2. #2
    Join Date
    Oct 2003
    Provided Answers: 1
    If your table is called Friends so you can choose all of them who has birtday in any entered month:

    SELECT, Friends.Birthday , Month([Friends.Birthday]) AS mon
    FROM Friends
    WHERE (((Month([Birthday]))=[Enter Month please:]));

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts