Limit Decimals in a Query ?

[captnk]

Is it possible to limit the number of decimal places to (say) 5 in a standard SQL query.
I am trying to do a query on a query to save making a number of unecessary tables,however I am getting a "type mismatch" quote which appears to be the result of the excessive decimal places where access puts someting like -3.12500E-05

If i append the answer to a table and (say) limit the table to 5 decimals places , the next query works fine,but it is very time consuming waiting to write 2 or 3 unecessary table.

Any ideas on this please
Regards

 

[RV]

You're getting an Type mismatch when you're trying to compare different datatypes.
Meaning your problem has nothing to do with decimal places...

Search the forums here for "type mismatch" to find similar issues.
Come back if you can't find your answer and / or need more assistance.

RV