Currency display

[mrosenberg]

I am working on a database that contains salary information on public employees. I am having difficulty sorting the salary field from highest to lowest as anybody making over 100k is ranked at the bottom instead of the top. I have the field set to currency.

Here is a link to the database under construction. Any help would be appreciated.

http://static.mgnetwork.com/cdp/test.html

[bahar_vm]

Hi,

I am sure the Salary field data type in the table is text where it needs to be number.

Navigate to the Tables section, select the table and click on Design button then change the data type of Salary field to \"Number\".

Best,

Bahar. M

[AtayBalunbalunan]

Please refer to this article for all the available data types in Caspio with examples on where to use each one.