asked on

How do I identify strange data in access 2007

I have a collection of data where every now and then an incorrect setting somewhere in the data that was used previously to calculate the result caused the result to be wrong.

It is somewhat fortunate that when it goes wrong ... it goes real wrong .... so at a glance it is obvious something is wrong but the sheer amount of data makes it incredibly hard to find it in the first instance.

See the data I have provided.

With the 49 items given that should be similar with an average value of .228 it is obvious that the two numbers of 2600 are incorrect .... or at least different

I have a means of segregating the data into what should be like groups

Is there a way access can flag the two odd records?

Thanks
Paul ExampleData.xls

ASKER CERTIFIED SOLUTION

Rey Obrero (Capricorn1)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Paul Burrows

ASKER

I am really trying to isolate data that is not the same. It need not necessarily be any particular number as each "group" of data could have different values, minimums, maximums, averages, etc

Paul Burrows

ASKER

For example if I have 40 values between 1 and 2 .... I would not consider a value of 100 to be part of that set

Rey Obrero (Capricorn1)

well, that will be difficult if you can not establish the correct parameters for pinpointing the incorrect values.

Paul Burrows

ASKER

Thinking back to my school days there was something called correlation that measured whether something was part of same group.

Too long ago

SOLUTION