does not match the defined precision of the column

[Bre-x]

The table in question have a Number Type Field, its field size is Decimal.
It is posible to create a query like this:

select * from mytable where myfield <> decimal?

I have a table with around 120,000 records and at least 20 fields

It is going to take an eternity to find where are those records that dont
compliant with the data type.

Thank you all,

Bre-x

 

[John Spencer]

I would think that if the number does not match the defined precision of
the column it would not be stored in the column.

Can you be a bit more specific on what you are trying to do? The number
1 will match any type of number field you can name. It can be displayed
with multiple trailing zeroes as 1.0000000000, but it will still be
stored as 1.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

 

[Bre-x]

Thank you for answering my post

The table in question has a field called qtycomp (Number Type, Field Size
Decimal, Precision 7, Scale 2)

there are record that show 6.0E+8, when it should show no more than 1,000
(Work Order Qty Completed)

when i try to sort the table or go to its last record
i got error: "The decimal field's precision is too small to accept the
numeric you attempted to add."

Now there are multiple fields with the same problem, and to make it worst i
have lots of tables with the same problem

is there a way to find out what records are the ones creating the problem?


Bre-x