Display fraction on specific way

G

Guest

Hi

if i have fraction number like .784 and i want to display it in report as
784/100 format is there is any function can do that?

Thanks
 
D

Duane Hookom

..784 is not 784/100. If you want to display it on a report as 784/1000, try
set the control source to an expression like:
=Trim(Str([YourField]*1000)) & "/1000"

Make sure the name of the control is not also the name of a field in your
report's record source.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top