Professional Web Applications Themes

Calculating the number of months - Microsoft Access

I need to calculate the Number of months that has passed from a certain date. I have a text box that called "Hold date" that stores the starting date and I have a text box called "Hold Time" that stores the total amount of hold time available. I need have the number of months that has passed calculated and then subtract it from the total hold time that is available. I appreciate any help...

  1. #1

    Default Calculating the number of months

    I need to calculate the Number of months that has passed
    from a certain date. I have a text box that called "Hold
    date" that stores the starting date and I have a text box
    called "Hold Time" that stores the total amount of hold
    time available. I need have the number of months that has
    passed calculated and then subtract it from the total hold
    time that is available. I appreciate any help
    Ben Guest

  2. #2

    Default Re: Calculating the number of months

    Check Access VB Help on the DateDiff() function.

    --
    HTH
    Van T. Dinh
    MVP (Access)



    "Ben Small" <com> wrote in message
    news:03d901c35d41$040db350$gbl... 


    Van Guest

  3. #3

    Default Re: Calculating the number of months

    And watch that the month difference (as is the year difference) is based on
    the month portion of the date, not on the actual days difference. Example,
    DateDiff returns a value of 1 if you test the month difference between 23
    April 2003 and 1 May 2003.

    --
    Ken Snell
    <MS ACCESS MVP>

    "Van T. Dinh" <bigpond.com> wrote in message
    news:phx.gbl... 
    >
    >[/ref]


    Ken Guest

Similar Threads

  1. Calculating number of users to watch streaming video ?
    By maith in forum Macromedia Flash Flashcom
    Replies: 1
    Last Post: November 6th, 02:25 PM
  2. calculating in tables
    By fisherman in forum Macromedia Exchange Dreamweaver Extensions
    Replies: 1
    Last Post: October 23rd, 09:05 PM
  3. Calculating age
    By Tom Thackrey in forum PHP Development
    Replies: 9
    Last Post: June 9th, 08:49 PM
  4. Calculating
    By Andreas Saarva in forum PHP Development
    Replies: 2
    Last Post: February 26th, 05:30 PM
  5. Calculating Dates
    By inzane in forum FileMaker
    Replies: 5
    Last Post: December 8th, 10:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139