I keep forgetting on how to order a column with datatype varchar One of my column for pricing has these values: 5,12,15,18,21,23,31 etc when I cfoutput my query result I got the list showing as:…
I used val(columnName) it seems to work with Access 2010. Please let me know if I'm wrong otherwise thank you for pointing to the right direction.
