Printable Version of Topic

Click here to view this topic in its original format

UtterAccess Forums _ Access Queries _ Format Percent

Posted by: RAZMaddaz Aug 15 2019, 12:03 PM

Hi Eveyone,

I am doing a basic IIf function, which within the IIf function, I am unable to use the FormatPercent function.

The following is what I am currently using in the IIF function:


I have placed the FormatPercent function everywhere with a "precision"of zero, and tried the Sum in the Formula in the Total row of the query and the Expression in the Total too, but nothing works.

Note: If I create another Field, I can use the FormatePercent using the other Field with the IIF function without a problem.




Posted by: ADezii Aug 15 2019, 12:33 PM

Perhaps I am misunderstanding the question, but with both Fields defined as Currency, the following will work just fine:


Posted by: RAZMaddaz Aug 15 2019, 12:46 PM


In the previous query all the values are currency, and I need to figure out what Percent of the Total Funds are used.

Now I can change the value in the Property Sheet and it will change the value to a Percent, but afterwords I need to use the Union ALL so that I can combine the Currency and Percent value and in previous queries I have created, that has not worked, in that the format on the second set of data would change to first set of data.