Format expession as percentage

[streub]

I have tried several scenarios to obtain a percentage format for the last part of the expression "([ort]-[discounted price])/[ort])"



PC: IIf(([ort]-[discounted price])/[ort]<0.01,"Best Price",([ort]-[discounted price])/[ort])

Currently the field displays "Best Price" where appropriate; however the numbers are in a string preceded with a decimal point.

Where should the formatpercent function be inserted?

[Minty]

Using the control's display format you can display text instead of a number.
So if you made the result Null or Zero you can use formatting as per https://msdn.microsoft.com/en-us/vba...ncy-data-types

And simply make it a percentage otherwise.

[ranman256]

in the query ,right click on the field ,set format=percent