Access query will not find the correct negative % numbers to be able to delete

[roem01]

When I run a query on the Percent Correct column in an Access 2013 for numbers less than 20% (-20) I get the results in Fig 1. I am only getting 6 results of negative numbers when there should be 113 negative numbers. What is causing this?

Fig 1

OverUnitCount	PercentCorrectUnitsToFills
92	-537.5
13	-423.785714
16	-109.791667
14229	-41.728477
14229	-41.728477
65170	-29.97315

I need the results to look like Fig 2 and find all of the numbers. My goal is to create a delete query that deletes all number greater than minus 20.00%, i.e. – 21.00, -30.00% etc. What criteria should I use for this field to find the correct numbers. I am not using SQL phrases, just design view.

Fig 2

OverUnitCount	PercentCorrectUnitsToFills
3718	-616.26%
293	-200.50%
43	-134.88%
8082	-114.50%
6678	-102.66%
11196	-99.95%
2745	-92.27%
408	-66.69%
295	-61.84%
155	-55.74%
182	-54.21%
659	-46.75%
7411	-40.75%

Thanks for your help

[June7]

Would have to review the data and query structure.

How will this be useful in a DELETE action?

[roem01]

I have uploaded the Access file to review and this is just a query to test that the information I want will appear in the query result. I will then create a delete query from this to delete the information in the table after appending more data weekly. The query information is in the last field named "PercentCorrectUnitsToFills". The problem is finding the information of negative numbers less than -20%. (such -37%, -40%, etc.)

[June7]

The field is a Double number type. It is formatted to display as percentage but the actual data is decimal. -46.7463% is really -0.467463. Try criteria: -0.2

I never set formatting in tables.

[roem01]

That worked! Thanks for your help.