Cant Sort?

[YouMust]

Strangely I cant sort my columns!

what do?

 

[plog]

Looks like they sorted fine to me. You have chosen the wrong field type for your data.

As numbers this list is sorted:

1, 2, 3, 10, 11, 12, 200

Now, if that list were strings they would sort like so:

1, 10, 11, 12, 2, 200, 3

From the looks of it, you've chosen the wrong datatype on a few fields. Also, when you assign values to field names, you are doing somelthing wrong as well (Sup_24V, Sup_10V, etc.). Most likely those values should go in a new table with the numeric part as values in a field, not field names.

 

[YouMust]

This table was automatically generated by labview.
All of the fields are set to 'long text'




but even the columns with only text in are still unsortable?
I'll get the other fields changed though I'm not sure if labview will revert them back. If it does then I'll have a look at labview.

thanks for your response plog

 

[plog]

No, Long Text fields can not be sorted at all.

 

[YouMust]

seems I'm unable to change any of them.

 

[isladogs]

If this a linked table you need to alter the design in the source db

 

[plog]

I would make a new empty table with the correct structure. Then run an APPEND query on the existing data to move the data to the corrected table.