Query calculates incorrectly

  • Thread starter Thread starter eft
  • Start date Start date
E

eft

I have a query with a field MalpracticeAdj: Malpractice *
MalpracticeGPCI. The MalpracticeGPCI changes for every
record queried. The first record should be .07 * .0966
= .006762. Instead it calculates to .06762. This is the
case for every record. What's wrong?
 
You haven't provided enough information. Post you calculation and the
actual values shwn in your table. There must be something going on your not
mentioning.

Kelvin
 

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

running total of records in query 1
Access Dcount (multiple criteria) 3
Count text values in a Access Field 0
Cartesian join in Access 0
Group by query question 1
Query Field Using Other Fields in the Query 3
using a calculation in a query 8
Yes / No query problem 4

Back
Top