Overflow in Query

[crcastilla]

I have a query that has the following two fields:



Rejects and Totals. I created a new field called "Percentage" and the following formula:

"Percentage: [Rejects]/[Totals]*1" to get the percentage of rejects.

When I run it the percentage field works fine but when I try to filter by percentage it says 'Overflow'

What can I do to fix this issue?

[ssanfu]

"Percentage: [Rejects]/[Totals]*1" to get the percentage of rejects.

Why are you multiplying by 1?

Is "Percentage" a field in a table? If so, what is the data type? The "Data Type" should be Number and the "FieldSize" should be Single or Double.