Querry Percent Format

[lmossolle]

I am using a querry to find a percent. Is there a way to format it to 85.6%
instead of .85666666. Thanks in advance...

 

[Jeff Boyce]

Open the query in design mode, right-click on the field, select properties,
set the format.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/