Change Autonumber from Random to Increment

[Bill]

I've inherited a table that someone changed the new value
property for an autonumber data type field from Increment
to Random. This field needs to be included on some reports
and the random numbers (including negatives) are spazzing
some users out. I've tried copying the table (structure
only), deleting the field, reinserting it with increment
set for the new value property, and then appending the
data back in. Even though the new field has the correct
properties, the new records are still coming in with the
random numbering scheme.

Does anyone have any suggestions?

TIA,
Bill

 

[Tim Ferguson]

This field needs to be included on some reports
and the random numbers (including negatives) are spazzing
some users out.

Why does the number need to be seen? The best answer for spazzed users is
simply to hide the architecture behind the wallpaper.

Failing that, you could always convert the number to Hex, so they just see
a long text-and-numbers string which is obviously meaninless and won't have
any minus signs.

HTH


Tim F

 

[Bill]

Tim,

Thanks. That's an easy, practical solution.

Best regards,
Bill

 

[Tim Ferguson]

Thanks. That's an easy, practical solution.

The best kind...

All the best


Tim F