GIStewart
asked on
Field appearing as text field in access query
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER