Add number in a field in Access

  • Thread starter Thread starter Konstadin
  • Start date Start date
K

Konstadin

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 said:
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?
Click to expand...

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
 
-----Áñ÷éêü ìÞíõìá-----


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


.
Click to expand...

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
 
Back
Top