Adding sort numbers incremented by 1 and showing decimal places 1

[netrusher]

I am sorting on the ChangeOrder field on my continuous form. Currently it defaults to 99. Is there a way that I
can have the number Start at 1 and increment by 1 depending
on how many records I am adding to the Table? If I am adding
20 Partnumbers i would like to have the numbers 1-20 in
the ChangeOrder field. The records are added to the database
via the continuous form for part numbers. Each time we add
part numbers they are tied to a specific ECN. The next ECN
that I add partnumbers might be 50 part numbers. I would like for them to be numbered 1-50 in the ChangeOrder Field.

Also in this change order field I would like to show 1
decimal place. If I have a 2.1 or a 4.5 I would like for
that to show up on the form and in the table. Now everything
keeps rounding up. My 2.1 shows as a 3, my 4.5 shows as a 5.
How can I avoid this?

 

[randy700]

Not sure how to correct the first part of your problem, but the second part should be fairly easy. It appears you have the field defined as an integer. Change it to a double for the decimal places to show.


Randy

 

[MajP]

You can do something like faq705-6727.