Multiplication in Query and Precision

  • Thread starter Thread starter sweez
  • Start date Start date
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?
 
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.
 
Back
Top