Subject: | Re: Number Format
| Date: | Wed, 23 Sep 2020 18:30:16 +1000
| From: | Tom Krieg <REMOVEtomkCAPITALS@sdassociates.com.au>
| Newsgroups: | pnews.paradox-programming
|
What's the business logic behind this?
On 23/09/2020 2:06 pm, Peter wrote:
> I cannot use rounded figures.
>
> I use these numbers for unique ID ("EntryID") in the first field of my
> table. I need to be able to insert new records in between sequentially
> numbered records:
> e.g.
> 1
> 2
> 3
> 4
> 5
>
> May need to become
> 1
> 1.1
> 2
> 3
> 4
> 5
>
> Further it may need to become
> 1
> 1.01
> 1.02
> 1.03
> 1.1
> 2
> 3
> 4
> 5
>
> Getting crazy
> 1
> 1.01
> 1.001
> 1.002
> 1.02
> 1.03
> 1.1
> 2
> 3
> 4
> 5
>
>
|