Table1
I have a table with a number field.
Form1
I have data entry form with that control bound to that table. This control is hidden on form, but has DMAX before update. So numbers keep increasing, while user enter data in the table via that form.
Form2
Now I want these numbers to be displayed on another form as ordinal number format like 1st, 2nd, 3rd, 4th etc instead of 1,2,3,4.
How can I get that?
thanks
I have a table with a number field.
Form1
I have data entry form with that control bound to that table. This control is hidden on form, but has DMAX before update. So numbers keep increasing, while user enter data in the table via that form.
Form2
Now I want these numbers to be displayed on another form as ordinal number format like 1st, 2nd, 3rd, 4th etc instead of 1,2,3,4.
How can I get that?
thanks
Last edited: