Dmax??

[racemadnss]

Hey All, Ive got a form that im trying to make my own auto number for, b/c I alread have another field using Autonumber.

Im using a text field b/c I want to have the Default value = "Autonumber" so that it appears to be an auto number.

Can you use DMax on a text field? If not is there any other way to find the max Number in a text field?

Thanks

 

[FoFa]

You can use Dmax, but remember a text field value is not numerically the same as a number value.

1
11
19
2
21
3

would be the order in text, and Dmax would return 3 and not 21 as you might think.

 

[racemadnss]

Oh, thats not cool...

hmm...I could change it to a number field but then I have to go do that on all the Related tables.

 

[FoFa]

If this is truly a sequencial field, why not pickup your current autonumber field value and use it in this field? Maybe you havn't explained it good enough for us to understand, can you clearify what you are actually trying to do besides use a "autonumber"?