User having a native Excel connection, has created a query in Query Builder with calculated fields. He would like to use Excel functions to format his fields. He would like to see numeric fields as currency and decimal point numbers in query results. How to use the listed Excel functions in Calculated Fields window in order format fields in query results?
1. In Calculated Fields formula window, provide a desired name for calculated field
2. Select Field Definition drop down
3. Select the Format function from list of functions
4. Select a table column name from list of column names
5. In the editable formula line, enclose embedded column name with brackets and add the "Currency" argument as such:
Format([<field name>],'Currency')
