Add Value to Numeric Field

Build your list of AccuZIP6 commands by requesting commands and sharing commands with other users

Moderators: Chrissy, Steve, Terry, Donna, Dave, Eric, MartyH, Kristen, Geoff, Vince

Post Reply
Posts: 726
Joined: Wed Sep 20, 2006 3:46 pm

Add Value to Numeric Field

Post by Kristen » Wed Dec 31, 2008 8:03 am

To add a numeric value to a field, for example if you have a field called "Age" and it has the value of 50 in it and you want it to calculate to 51, you can do the following:

1) Pull the Edit menu down to fields and make sure that the field Type is Numeric
2) Pull the Edit menu down to Command and create a new command
3) In the Command Statement Syntax Box type the following:
Replace all age with age+1
4) Click RUN

Post Reply