NUMBER PLUS 1

T

terry

I have a field that i imput a starting number and would like the next field
to be the number I input plus 1 what is the expression I need to use

Thank you
 
F

fredg

I have a field that i imput a starting number and would like the next field
to be the number I input plus 1 what is the expression I need to use

Thank you
Click to expand...

On your form, in the control's Default property, write:
DMax("FieldName]","TableName]")+1
 
T

terry

Added the code you suggested, no numbers are displayed in the next field
here is some additional information
the first field is called start number(this is the field I add the starting
numberto) the second field is c1
when you say In the controls Default property add the following :
dmax("FieldName]","TableName]")+1 are you refering to the start number field
or the c1 field . I have tried it both ways with no success

Thank you for your time and help

--
Terry


fredg said:
I have a field that i imput a starting number and would like the next field
to be the number I input plus 1 what is the expression I need to use

Thank you
Click to expand...

On your form, in the control's Default property, write:
DMax("FieldName]","TableName]")+1
Click to expand...
 
F

fredg

Added the code you suggested, no numbers are displayed in the next field
here is some additional information
the first field is called start number(this is the field I add the starting
numberto) the second field is c1
when you say In the controls Default property add the following :
dmax("FieldName]","TableName]")+1 are you refering to the start number field
or the c1 field . I have tried it both ways with no success

Thank you for your time and help
Click to expand...

this was your original question:
I have a field that i imput a starting number and would like the next
field to be the number I input plus 1 what is the expression I need to
use


In the Default Property of the [Start Number] or is it the [C1]
control, write:
DMax("[Start Number]","WhateverTheTableNameIs")+1

If there is a possibility of [Start Number] being Null (nothing
entered) then write:
Nz(DMax("[Start Number]","WhateverTheTableNameIs"),0)+1
 
R

Rick Brandt

terry said:
I have a field that i imput a starting number and would like the
next field to be the number I input plus 1 what is the expression I
need to use

Thank you
Click to expand...

Next *field* on the same record or same field on the next *record*?
 
Top