Search results

i tried this and working. But i wonder why the format function whose purpose is to display as ##.##% is not working as expected. Is it a known thing? Anyway thanks. It helped

Still It displayes the same format.2300.00% =Format([AE_POCRate],"00.00%") Above is the expression used. I dont think i am wrong here. Looks weird :confused: Is there something else that i can do just to display correct percentage format and not store in table.

Hi, I am new to Access and working a Report to display a Percentage value. The value in db is a text type with value 23 But when i apply Format = Percent in design view of Reports it renders it as 2300.00% while the expected is 23.00% . Please help me with this.