Querry Percent Format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lmossolle - 10 Apr 2006 14:20 GMT

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...

Reply to this Message

Jeff Boyce - 10 Apr 2006 14:59 GMT

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

Signature

Regards

Jeff Boyce
Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

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

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

> 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...

Reply to this Message