Getting "Invalid precision for decimal data type"

D

Dirtbike

I'm doing some pretty straight forward stuff. First I gather some sales
order details to a table (with a maketable). Then I do some averaging. Then
I do some final reporting. With a SELECT type query of this averaged data I
get a screen in info just as expected. When I try to multiply one of the
fields by a multiplier I get the "Invalid precision for decimal data type"
error. The multiplier is a number of 'single' precision. When I try to
multiply the field by 1 I don't get the error. When I multiply by the field
value of 1 I get the "Invalid prec..." error.
With the "second" query I forced the type to be fixed to 2 decimals so my
average numbers don't look like 6.263407672445 there 6.26 will do....is this
the "root" of my problem?
 

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

Internal Data Integrity (Type 4) Details Needed 1
What type of inboxes do these icons represent 0
Invlaid precision for decimal problem 1
Format query result as Data Type Number, Field Size Decimal 3
Problems With Precision while Linking Tables 4
Invalid precision for decimal data type 0
How to paste this down? 3
Change Precision and Scale 2

Top