MS Access Reports

Discussion in 'OT Technology' started by pimphat, Jan 23, 2005.

  1. pimphat

    pimphat hmmm

    Joined:
    Sep 18, 2002
    Messages:
    5,701
    Likes Received:
    0
    Location:
    Australia
    I'm trying to display a page with people's birthdays grouped by months in Access. I believe it is appropriate to use a report to do this.. When I try to do it Access is grouping by months but it will distinguish between say January 1980 and January 1981 when I just want anything in January. How would I go about fixing this :/
     
  2. 5Gen_Prelude

    5Gen_Prelude There might not be an "I" in the word "Team", but

    Joined:
    Mar 14, 2000
    Messages:
    14,519
    Likes Received:
    1
    Location:
    Vancouver, BC, CANADA
    Create another field in the query results that says:

    BirthMonth: Month([Birthdate])

    Then group on that.

    You don't need to use Reports unless you want to output the results in some fancy layout. If you just want the data, you can just use a query.
     

Share This Page