Sort subform records on a main form

[vazdajic]

Hello there..
As a picture below explains, I will just thank to everyone who will reply to this. Thanks.

[ranman256]

text will not sort like numbers.
in the query you can get close by converting it to a 'number':
val([weld])

or
actually alter the field type to a number.

[isladogs]

As Ranman has already said you can't do this with your current data as its text so sorted one character at a time

Ideally convert to number field but you'd need to alter 2/1 , 3R1 etc
Alternatively, have an additional (hidden?) number field so 2/1 becomes 21, 3R1 becomes 31 etc ... but that will give yet another sort order

[ArviLaanemets]

The only option remaining is an additional column (as you have also values like "2/1", this must be text, and you don't show this column anywhere in forms - it is for ordering/sorting only), where same numbers are with leading zeros, like "01", "02", "02/1" etc. (you have to estimate the biggest possible number, to determine the number of leading zeros - in case it is p.e.1000, you must have numbers like "0001", "0002", "0002/1" etc.).

[isladogs]

you must have numbers like "0001", "0002", "0002/1" etc

You obviously mean text that looks like numbers as none of these are numbers

[vazdajic]

Yeah, I have numbers saved as text. Acc. to QC rules, I am not allowed to have zeroes visible (e.g. 01, 001 etc). Also, sometimes I have letters in weld number field.. Hm.. Thanks for advices..

For now, I will define additional numeric field which I will use just to sort values. It will be visible on my form but not on reports.

Thanks everyone.