Multiplication in Query and Precision

S

sweez

I need help with something that appears as if it should be very simple
but I can not figure it out. I have a query in MS access 2003 that
multiplies two numbers, each from a different table. The fields in
these two tables are formatted as:

Field Size: Double
Format: Standard
Decimal Places: Auto

The result I get is an integer (no decimals) when I know it should be
several decimal places long. Does anone know what I am dong wrong?
 
J

Jerry Whittle

Hi,

Show us the SQL statement for the query or at least the calculated field in
the query.

Also right click on the field in question and bring up its properties. Make
sure that it isn't formatted with 0 decimals or something similar.
 

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

Access stripping decimal places in query 1
Format query result as Data Type Number, Field Size Decimal 3
Lost decimal precision for single and double number format-Access2 4
Make table query changes precision of number field 3
Getting "Invalid precision for decimal data type" 1
change format in make table query 2
Display decimals on query 6
Query Sum Function Decimal Precision 3

Top