query field help

  • Thread starter Thread starter ryan.fitzpatrick3
  • Start date Start date
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
 
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
Expression Problem 3
How not to display/print zero values in form fields in Word? 2
combing several fields into one 3
Field Properties: Decimal Places - DOES NOT WORK!!! 1

Back
Top