Query ignoring criteria ONLY with parameters

[Lluewhyn]

I have a query that is calculating results as a percentage. Each record is a combination of different components, and the query calculates what percentage each component is of the total (there's even a sanity check at the end that adds all components up and divides by actual Total record to ensure 100%).

So far, so good. Now, the purpose for the query is to search for records that may have values higher than certain values. The parameter works if I hard-key it in the Design View, but not if I put a Parameter to prompt the User for the value! For simplicity, I am troubleshooting with the format of decimals as opposed to percentages.

Example
Criteria = >.2 --->This is executing successfully and only pulling up those records where that component is greater than 20% of the total.

Criteria = >[Enter Component Minimum %] (I enter ".2") --->This pulls up every record, even ones where value is lower than 20%.

Any ideas?

[CJ_London]

just to clarify, do you actually enter ".2" or .2?

try entering 0.2

the query may be interpreting your input as a string so try entering 0.2

also try modifying your criteria to

Criteria = >CDbl([Enter Component Minimum %])

but wouldn't it be more natural to enter 20 when asked for a percentage? so criteria would be

Criteria = >CDbl([Enter Component Minimum %]/100)

[Lluewhyn]

I was using quotations only for clarification. However, your solution for the CDbl seems to work. Thanks!