RyanLocke1
3 years agoQrew Cadet
Auto Number
I am migrating some data from another system that already had a UniqueID and the records started at 10,000 originally because I don't think the data set was going to get big I just did this so if it was 0, just default to the Record ID, but I think it will be good to start off where they left off so I was wondering how to use this formula but have it start an auto number at 11,000?
If(Nz([NF Owner Number])=0,[Record ID#],[NF Owner Number])
------------------------------
Ryan Locke
------------------------------
If(Nz([NF Owner Number])=0,[Record ID#],[NF Owner Number])
------------------------------
Ryan Locke
------------------------------