query field help

R

ryan.fitzpatrick3

I have two query fields one which divides into the other. i.e. fieldA
divided by fieldB = fieldC, easy enough, except that instead of
getting an answer such as 2752/2800 = .9828 it gives me .90 it rounds
it. I went into format field to standard and I added decimal places
but the answer in fieldC still reflects .90 instead of .9828. Any
thoughts?

Ryan
 
K

KARL DEWEY

Which field are you formatting? You do know that formatting is for the
display and not for the divisor or dividend.
 
Top