E
Eric @ SEASH, Evansville
I have a query that works fine, except that the percentage increase field
will not display data properly. It is a field that gets it's value from a
form. On the form the field is formatted as Percent, but in the query I have
no format choices. For example, if on the form I input 0.02, when I tab to
the next field on the form that value changes to read 2.0%, which is exactly
what I want. When I then click on the button that executes the query, the
reported percentage increase shows up as four small squares, however when I
simpy execute the query directly (not from the form) the percentage increase
shows up as .02. Any ideas what's going on with this ?
Thanks !
will not display data properly. It is a field that gets it's value from a
form. On the form the field is formatted as Percent, but in the query I have
no format choices. For example, if on the form I input 0.02, when I tab to
the next field on the form that value changes to read 2.0%, which is exactly
what I want. When I then click on the button that executes the query, the
reported percentage increase shows up as four small squares, however when I
simpy execute the query directly (not from the form) the percentage increase
shows up as .02. Any ideas what's going on with this ?
Thanks !