Invlaid precision for decimal problem

G

Guest

Hi. I am trying to run a crosstab query that will average a series of
numbers. I get an "Invalid precision for decimal data type" error. Do you
have a recommendation to fix this? The data type is set to general number.

Thanks!
 
M

Michel Walsh

Hi,


I *suspect* you use a decimal data type number WITH a format set as a
general number. The data type is how the number is stored, the format is how
the number is presented to the user interface (by default, if not otherwise
explicitly formatted). It seems your storage limit for the decimal number is
reached. You have to increase it (from table design, for the implied
field(s). The Access terminology, for such field, is Data Type = Number,
and in the small section at the bottom, when the field is selected, you can
read Field Size = Decimal and Precision = ... a number between 1 and 28.
It is probably too low, try to increase it.

I started with a: I *suspect* because clearly, the problem can be
something else, given the imprecision of the context.



Hoping it may help,
Vanderghast, Access MVP
 

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

Getting "Invalid precision for decimal data type" 1
Format query result as Data Type Number, Field Size Decimal 3
Access stripping decimal places in query 1
Cross tab problem 1
change data type from decimal to double 2
Problems With Precision while Linking Tables 4
Formatting sums in crosstab? 7
Lost decimal precision for single and double number format-Access2 4

Top