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 w...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendTry this
If(Nz([NF Owner Number])=0, [Record ID#]+11,000 , [NF Owner Number])
but then you would change the 11,000 to a lower number to reflect how many records were used up by the imported data.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
If(Nz([NF Owner Number])=0, [Record ID#]+11,000 , [NF Owner Number])
but then you would change the 11,000 to a lower number to reflect how many records were used up by the imported data.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------