query field help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ryan.fitzpatrick3@safeway.com - 22 Apr 2008 17:00 GMT

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

Reply to this Message

KARL DEWEY - 22 Apr 2008 20:25 GMT

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

Signature

KARL DEWEY
Build a little - Test a little

> I have two query fields one which divides into the other. i.e. fieldA
> divided by fieldB = fieldC, easy enough, except that instead of
[quoted text clipped - 4 lines]
>
> Ryan

Reply to this Message