Results 1 to 3 of 3
  1. 12-07-2014, 04:09 PM #1
    tareyj8569
    tareyj8569 is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Aug 2009
    Posts
    43

    Count Exact Days (SOLVED)


    Hey all,

    What I am trying to accomplish is there is 2 fields, user picks first date Lets say 12/1/2014 then user picks 2nd date 12/3/2014. Is there a way to count the exact amount of days so the answer would be 3. Not the Between which gives 2 days.

    Thanks for your time and help!
    Last edited by tareyj8569; 12-07-2014 at 04:54 PM. Reason: (SOLVED)
    Reply With Quote Reply With Quote
  2. 12-07-2014, 04:45 PM #2
    June7's Avatar
    June7
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,972
    Add 1 in the calc.
    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.
    Reply With Quote Reply With Quote
  3. 12-07-2014, 04:54 PM #3
    tareyj8569
    tareyj8569 is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Aug 2009
    Posts
    43
    Ha, yea that will defiantly do! Thanks
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Count Days...
    By sdc1234 in forum Queries
    Replies: 1
    Last Post: 02-06-2014, 09:31 AM
  2. Count how many days since and on what date
    By burrina in forum Queries
    Replies: 28
    Last Post: 01-26-2013, 11:57 AM
  3. Count Sunday & Saturday between two days.
    By kashif.special2005 in forum Queries
    Replies: 2
    Last Post: 02-23-2012, 06:19 PM
  4. Count number of days
    By ramindya in forum Queries
    Replies: 1
    Last Post: 02-22-2012, 04:47 PM
  5. Count days past a set date
    By tsn.s in forum Access
    Replies: 2
    Last Post: 12-01-2011, 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums