Results 1 to 2 of 2
  1. #1
    FJM is offline Competent Performer
    Windows 98/ME Access 2003
    Join Date
    Jun 2010
    Posts
    117

    Report date conversion

    I have a report which lists when a series of individual audits have been completed.
    Each individual audit has a completion date.
    I would like to have a text box in the page header of this main report which groups the individual audits into Months
    e.g if any audit completion date is between 01/01/2016 and 31/01/2016 the the text box will show JANUARY 2016
    if any audit completion date is between 01/02/2106 and 28/02/2016 te text box will show FEBRUARY 2016 etc etc
    Can this be done ?

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,932
    use the format function

    format(auditcompletiondate,"mmmm yyyy")

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

Similar Threads

  1. Conversion Date to Words
    By sanbhau in forum Modules
    Replies: 2
    Last Post: 04-21-2016, 05:39 AM
  2. English <==> American Date conversion
    By tb1150 in forum Access
    Replies: 1
    Last Post: 06-22-2015, 05:19 AM
  3. Date Conversion
    By mslenker in forum Access
    Replies: 1
    Last Post: 01-30-2013, 09:52 AM
  4. Date Conversion
    By mkc80 in forum Access
    Replies: 1
    Last Post: 06-27-2012, 04:04 PM
  5. Access VBA - date format conversion
    By benattal in forum Programming
    Replies: 3
    Last Post: 12-22-2008, 10:40 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