Nz function is eiliminating my % formatting in calculated field.

[MLangendorf]

How can I maintain the 'percent' formatting of calculated field of query when using the Nz function?


Obviously it is written to return a '0' if either of the fields used in the calculation is zero but it removes the percent formatting on field for all of the calculations that are 'normal'.
Is there a way to fix this?

Thanks Everyone!

% Wt Change: Nz((Round((([Tbl_ClinicalFUData]![Weight])/([Tbl_ClinicalData]![Weight])-1),2)),'0')

[Bulzie]

Format (Nz((Round((([Tbl_ClinicalFUData]![Weight])/([Tbl_ClinicalData]![Weight])-1),2)),'0'), "Percent")

There is also a FormatPercent function you can look up that might do what you need.

[MLangendorf]

Thx Bulzie,
This worked nicely!
I appreciate your help.

[Bulzie]

Glad I could help!!