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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query field question 5
Adding an autonumber field in a query? 4
Update Query Without Replacing Text 3
Converting "row_number()" Query Into Access 2007 Format 0
Field Properties: Decimal Places - DOES NOT WORK!!! 1
Make a field lookup dependent on the value in another field of a record? 11
Update query doesn't show correct format 1
Make table query changes precision of number field 3

Top