Results 1 to 1 of 1
  1. #1
    Ushera is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2009
    Posts
    5

    a query that will return this month's records

    I am trying to create a query that will return this month records (the records are under the field "enddate" and the format is date/time)

    I have tried this but it is not working:
    PARAMETERS [Enter Current month] DateTime;
    SELECT Interns, Companies, "Position title", startdate, Enddate
    FROM Table1
    WHERE


    MONTH(GETDATE([Enter current month]))=MONTH(GETDATE(enddate))
    ORDER BY enddate;


    AND IMPORTANT!!
    I can not use "getdate ()" on ms access is there another way please??
    what am I doing wrong?

    Thanks for the help!!
    Last edited by Ushera; 08-04-2009 at 10:51 PM.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 01-29-2009, 02:43 AM
  2. Replies: 0
    Last Post: 11-12-2008, 05:18 PM
  3. Return Record # In Query
    By redwinger354 in forum Access
    Replies: 1
    Last Post: 09-15-2007, 01:08 PM
  4. query that will contain all unique records
    By halcolm1 in forum Queries
    Replies: 0
    Last Post: 01-19-2007, 05:34 PM
  5. Return records not updated by update query
    By ars80 in forum Queries
    Replies: 2
    Last Post: 05-01-2006, 09:23 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums