Results 1 to 2 of 2
  1. #1
    mlrucci is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2018
    Posts
    202

    Month Day only for grouping in a report

    Good afternoon, I am attempting to create a report based on birthdates. In my table, my DateBirthday format for the employee is mm/dd, Input mask is 99/99;;_. This will result in 04/25 without the year. The employees do not want others knowing their age. When I use the create a report and group so that all the birthdays for the month of Jan, Feb, Mar are all grouped according to their month, I get the months repeated over and over. It appears access is giving the dates a year. Thus, giving the repeated months over the years (Jan 2018 and Jan 2019 ect.). How can I get the report to show all the employees in the moth of Jan to group together not based on the year? ??default the year to 2050???? at a loss on this one. Any help would be appreciated.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    If you input into a date/time field then Access will assume a year. Then you will have to use formatting to prevent the year component display. The grouping value does not have to be displayed. Format textbox for what you want to show.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Grouping By Month, Year
    By Alex Motilal in forum Reports
    Replies: 1
    Last Post: 03-24-2019, 05:47 AM
  2. Replies: 4
    Last Post: 10-31-2018, 04:58 PM
  3. Replies: 1
    Last Post: 08-09-2017, 02:49 PM
  4. Grouping by Month in Report
    By ccordner in forum Reports
    Replies: 2
    Last Post: 12-20-2011, 09:05 AM
  5. Replies: 4
    Last Post: 04-09-2011, 10:39 AM

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