NUMBER PLUS 1

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

terry - 20 May 2005 15:28 GMT

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

Signature

Terry

Reply to this Message

fredg - 20 May 2005 15:48 GMT

> 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

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

Signature

Fred
Please only reply to this newsgroup.
I do not reply to personal email.

Reply to this Message

terry - 20 May 2005 19:19 GMT

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

Signature

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
[quoted text clipped - 3 lines]
> On your form, in the control's Default property, write:
> DMax("FieldName]","TableName]")+1

Reply to this Message

fredg - 20 May 2005 23:02 GMT

> Added the code you suggested, no numbers are displayed in the next field
> here is some additional information
[quoted text clipped - 5 lines]
>
> Thank you for your time and help

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

Signature

Fred
Please only reply to this newsgroup.
I do not reply to personal email.

Reply to this Message

Rick Brandt - 21 May 2005 00:00 GMT

> 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

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

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message