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? 3
Update Query Without Replacing Text 3
Conditional statements in MS-Query? 0
Stored Procedure? 4
Erratic Report Field Format 6
Unusually long decimals for Actual Work 0
Query Sum Function Decimal Precision 2

Top