Results 1 to 2 of 2
  1. #1
    Alex Motilal is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Nov 2008
    Location
    Coimbatore, India
    Posts
    180

    Statement Title with date range

    To generate a report, I am using a Dialog Box with two dates. What I want is:



    1) If the First Date & Last Date of the Dialog Box are of the First & Last Dates of a particular month , eg. 1 Dec 2019 & 31 Dec 2019, the title should be as:

    STATEMENT FOR THE MONTH OF DECEMBER, 2019

    2) If the First Date & Last Date are different or not the first & last dates of the month, eg. 1 Dec 2019 & 10 Dec 2019, the title should be as:

    STATEMENT FOR THE PERIOD FROM 1 DEC 2019 TO 10 DEC 2019

    Thanks
    Last edited by Alex Motilal; 01-11-2020 at 11:30 PM. Reason: saved befor completing

  2. #2
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    6,713
    You've solved this already? Care to post your solution for others in the future?
    - "doesn't work" doesn't help. Implement changes in copies of your database.
    "Everyone has a photographic memory; some just don't have film." Steven Wright

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

Similar Threads

  1. Replies: 4
    Last Post: 11-20-2018, 11:57 PM
  2. Replies: 17
    Last Post: 07-31-2018, 01:23 PM
  3. Replies: 3
    Last Post: 01-26-2016, 01:56 PM
  4. Replies: 22
    Last Post: 01-23-2015, 01:16 PM
  5. iif statement using a range (between)
    By denver1717 in forum Access
    Replies: 3
    Last Post: 10-03-2012, 07:05 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
  •  
Tech Forums: Microsoft Office Forums