NUMBER PLUS 1

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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...
 
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
 
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*?
 
Back
Top