Ask a Question Sign up for Free 100 Experts currently online. Ask Questions for Free!

Add number in a field in Access - Microsoft Access

In a field from a Form in the Access I want per Month automatically added (+1). For example in a field exists number 5, the next Month automatically and whenever I open the program it has become 6, the next Month 7 etc. What it should I make (question, macro, ...

Results 1 to 3 of 3

  1. #1

    Add number in a field in Access

    In a field from a Form in the Access I want per Month
    automatically added (+1). For example in a field exists
    number 5, the next Month automatically and whenever I
    open the program it has become 6, the next Month 7 etc.
    What it should I make (question, macro, code) and how?
    Thanks.


    Konstadin
  2. #2

    Re: Add number in a field in Access

    "Konstadin" <com> wrote in message
    news:11a801c372b4$ab718850$gbl... 

    It appears as though you need the DateAdd function:

    DateAdd(interval, number, date)

    In your case it would look like:

    DateAdd("m", 1, Me.txtDateFieldControlName)
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads:
    http://www.datastrat.com
    http://www.mvps.org/access


    ---
    Outgoing mail is certified Virus Free.
    Checked by AVG anti-virus system (http://www.grisoft.com).
    Version: 6.0.514 / Virus Database: 312 - Release Date: 8/28/2003


    Arvin
  3. #3

    Re: Add number in a field in Access

     
    (http://www.grisoft.com). 
    8/28/2003 

    Thanks ARVIN. but still I cannot make it. I will try to
    be more explicit.
    The Form I name "Chief "and the Field "Total", in the
    Field every Month I write a number with the hand and this
    number of each Month it changes adding + 1, For example,
    in August I put number 4, in September it must put 5, in
    October 6 etc, this process I want automatically becomes
    and no by hand every Month.
    Thank.and if it is possible for you write step by step.
    Have a nice day

    konstadin

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