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?
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?