Results 1 to 3 of 3

Date text field won’t display end date in report header

  1. #1
    ACu is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Dec 2018
    Location
    Mississippi
    Posts
    6

    Date text field won’t display end date in report header

    I have a program I made at work that runs a report based on a query that searches a start and end date. I want both dates to appear in the header box. The text box displays just the start date. =Format$([Tour Date] “mmmm dd yy”,0,0). I want both dates to display. What do I need to add to that text box to show the end date?

  2. #2
    moke123's Avatar
    moke123 is online now Me.Dirty=True
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Posts
    299
    =Format$([Tour Date] “mmmm dd yy”,0,0) & " To " & Format$([Your End Date Field Name] “mmmm dd yy”,0,0)

  3. #3
    ACu is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Dec 2018
    Location
    Mississippi
    Posts
    6
    moke123 thank you for your help on this. I really appreciate it.

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

Similar Threads

  1. Replies: 10
    Last Post: 01-23-2016, 12:29 PM
  2. Replies: 6
    Last Post: 06-26-2015, 08:55 PM
  3. Replies: 20
    Last Post: 01-13-2015, 02:23 PM
  4. Replies: 9
    Last Post: 04-18-2014, 08:51 PM
  5. Replies: 3
    Last Post: 09-11-2013, 09:49 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