I have created a query to extract certain data for download to excel. As I don't want null or zero values to be converted I have built an IIF expression selecting only values greater than zero. IIf(([Wage]![entry]>0),([Wage]![entry]),"").
While the table values are formatted as currency the query yields values that have infinite decimals and that are not read by excel as a number even tho I have set the property in the query expression to currency. Any suggestions as to what I may have done wrong.
While the table values are formatted as currency the query yields values that have infinite decimals and that are not read by excel as a number even tho I have set the property in the query expression to currency. Any suggestions as to what I may have done wrong.