G Guest Apr 10, 2006 #1 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...
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...
J Jeff Boyce Apr 10, 2006 #2 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/
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/
