I have a Select query that returns a value based on an IIF and DLookup statement. I am looking up a number in another table, based on a number falling between 2 numbers. However, the query returns a text field, and even if I format it as a number via Field Properties, it is still seen as a number when I sort the column or download the data to excel. It also doesn't allow me to select the number of decimal places. Any ideas?