<div>
Thank you. &nbsp;Val(fieldname) worked just as I was hoping
</div>


Thank you.  Val(fieldname) worked just as I was hoping

<div>
<div class="content wysiwyg-content">
I have a Select query that returns a value based on an IIF and DLookup statement. &nbsp;I am looking up a number in another table, based on a number falling between 2 numbers. &nbsp;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. &nbsp;Any ideas?
</div>
</div>


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?

Field appearing as text field in access query

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.