Results 1 to 5 of 5
  1. #1
    AndyC121 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2015
    Posts
    37

    Automatically Display days remaining

    I am trying to display a real time count down of days left from a defined date on a form.
    I have a field "DispatchDue" calculated from a field"GoodIn" which is normally todays date. I would like a count down of days remaining until "DispatchDue". I have tried various options using datediff and Now() functions but cant get it to do what I require.Is it possible to have a count down of days left in real time and either add this to my table or display it on my form?
    so say theres a date in my field DispatchDue 28/03/2017 I would like it to display : "6 days Remaining"
    so it looks at todays date and then minus from dispatchdue but I want it to automatically do it each day.

  2. #2
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    So, assuming the field on your Form is called "Dispatch Due" and is a valid date field, you can create a calculated field on your Form and set this as its Control Source:
    Code:
    =[DispatchDue]-Date() & " Days Remaining"

  3. #3
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    =DateDiff("d",date(),[DispatchDue]) & " days remain"

  4. #4
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    =DateDiff("d",[DispatchDue],date()) & " days remain"
    If you use DateDiff, you will want to flip those dates around, since DispatchDue seems to be the future date.

  5. #5
    AndyC121 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2015
    Posts
    37
    Thank you all seems to be working now

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

Similar Threads

  1. Automatically Insert rows with Days in Months
    By NoviceAccess in forum Access
    Replies: 10
    Last Post: 08-30-2016, 06:00 PM
  2. Display Remaining Units within time frame
    By Stanggirlie in forum Access
    Replies: 3
    Last Post: 01-05-2013, 10:44 AM
  3. Replies: 3
    Last Post: 04-15-2012, 09:53 AM
  4. Replies: 5
    Last Post: 04-01-2012, 07:21 AM
  5. Drop-Down list to display remaining text.
    By mnsemple83 in forum Forms
    Replies: 3
    Last Post: 07-18-2011, 10:29 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