M markl New Member Aug 12, 2009 #1 I want to create a report that uses a field that is a text field. I would like to be able to sort it so that anything that looks like a number is sorted as a number (similar to what Excel does) Thanks Markl
I want to create a report that uses a field that is a text field. I would like to be able to sort it so that anything that looks like a number is sorted as a number (similar to what Excel does) Thanks Markl
M Manturo New Member Aug 12, 2009 #2 Try in your by statement the Integer function. It has worked for me. Example: for each TABLE no-lock by int(text_number field).
Try in your by statement the Integer function. It has worked for me. Example: for each TABLE no-lock by int(text_number field).
