O okendra New member Local time Today, 00:29 Joined Nov 28, 2007 Messages 1 Nov 29, 2007 #21 Table sort I am trying to sort the query table of 1, 4, 5, 6, 7,1-2, 3-4, 5-6, 9 10....so on Now how do i sort this table without 1-2, 3-4, 5-6. I tried Not Like"-" but did not work. please help me export.
Table sort I am trying to sort the query table of 1, 4, 5, 6, 7,1-2, 3-4, 5-6, 9 10....so on Now how do i sort this table without 1-2, 3-4, 5-6. I tried Not Like"-" but did not work. please help me export.
M MStef Registered User. Local time Today, 08:29 Joined Oct 28, 2004 Messages 2,250 Nov 29, 2007 #22 Hello okendra! If you want to sort the table via this field as NUMERIC, you can't do this, because it is a TEXT field. You can do it via query. Look at "DemoSortTextFieldA2000.mdb", look at Query1, column f11. Attachments DemoSortTextFieldA2000.zip DemoSortTextFieldA2000.zip 7.4 KB · Views: 114
Hello okendra! If you want to sort the table via this field as NUMERIC, you can't do this, because it is a TEXT field. You can do it via query. Look at "DemoSortTextFieldA2000.mdb", look at Query1, column f11.
