Results 1 to 2 of 2
  1. #1
    bonds762 is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Feb 2017
    Posts
    1

    How To Calculate a Date Value Based off of Combo Box Values

    Hello,
    So I'm fairly new to access and most of my knowledge has been based off of messing things up and then trying to fix them. I've tried using a text box with formulas in place but can't seem to calculate correctly. My question is as follows: Can I calculate a date based off of values in a combo box? I'm trying to have a final date calculated based off of a combo box values? For example: If AA=45 days, BB=35 days, and CC=55 days, can I have the date calculated from present day + AA = final date? There is one additional thing. There are times when AA will have already started. Assume AA started 12 days ago and I need to calculate from present day, plus the remaining 23 days left, and still calculate the final date. I apologize if this is confusing. Thank you for the help.

  2. #2
    Micron is offline Very Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    13,423
    I think you mean 33 days left (45-12) not 23? Your dates are date data type and the days values are numbers - not text?
    If they are not text, you can do what you want with the DateAdd function https://www.techonthenet.com/access/functions/
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

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

Similar Threads

  1. Calculate Due date based on drop down list
    By Back2Basics in forum Access
    Replies: 2
    Last Post: 04-02-2015, 06:10 AM
  2. Replies: 1
    Last Post: 11-26-2013, 09:25 AM
  3. Replies: 3
    Last Post: 07-03-2013, 10:38 AM
  4. Replies: 34
    Last Post: 12-01-2011, 08:18 AM
  5. Replies: 1
    Last Post: 03-27-2010, 06:13 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