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:

Expr1:IIF([Lodging_Cost]<>0,[Funds_Allocated]/[Lodging_Cost],0)

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.

Suggestions?

Thanks!

RAZMaddaz

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:

CODE
Expr1:IIf([Lodging_Cost]<>0,FormatPercent([Funds_Allocated]/[Lodging_Cost],0),0)

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

ADezil,

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.

RAZMaddaz