Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Sep 2002
    Posts
    180
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Current Month Query (Access 2003)

    I need to make reports based on dates: Current, Last Month, 3 Months , Year to Date.

    I search and found most of the answers except for the Current month.

    I was looking at this post:
    Comparing records for last two months (2003)
    <post:=700,889>post 700,889</post:>

    I could not get it to work with the Min and Max functions so I will just ask.

    If I have a table with Dates on it (in Date Format) How can I report on all records with the Current month only?

    Thanks

  2. #2
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Current Month Query (Access 2003)

    <P ID="edit" class=small>(Edited by mbarron on 06-Aug-08 14:26. Screenshot was not correct)</P>You can filter on both the month and year where Year([DateField]) = Year(Now()) and Month([DateField]=Month(Now())
    Attached Images Attached Images

  3. #3
    2 Star Lounger
    Join Date
    Sep 2002
    Posts
    180
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Current Month Query (Access 2003)

    Thnk you very much...
    That worked!!!!

Posting Permissions

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