G
Guest
When I run my query to make a new table using the formula below (A) I retrun
a numeric value with varying number of decimals. The field properties in the
query are set to percent. When I try to format my results as a percentage the
query returns a text value (B). Is there a way for me to format my query to
bring the results back as a numeric value in percent format?
(A) CM_Billable_%: [CM_BIlled]/IIf([CM_Scheduled]=0,0.01,[CM_Scheduled])
(B) CM_Billable_%: Format([CM_BIlled]/IIf([CM_Scheduled]=0,0.01,
[CM_Scheduled]),"Percent")
a numeric value with varying number of decimals. The field properties in the
query are set to percent. When I try to format my results as a percentage the
query returns a text value (B). Is there a way for me to format my query to
bring the results back as a numeric value in percent format?
(A) CM_Billable_%: [CM_BIlled]/IIf([CM_Scheduled]=0,0.01,[CM_Scheduled])
(B) CM_Billable_%: Format([CM_BIlled]/IIf([CM_Scheduled]=0,0.01,
[CM_Scheduled]),"Percent")