Can anyone help please.
I have a table with a field called Links. This field contains several ID numbers all separated by a carriage return.
If I sort the table on the Links field it doesn't seem to be giving me the right sequence.
I've attached a screenshot of part of the table when exported to Excel. Row 18 should appear between rows 11 and 12 but it looks like the sort isn't working. I put zeroes at the end of every field just to eliminate (prove) there were no hidden characters.
If I sort the Excel file on Column D 'Links" I get the right result..
Many thanks in advance