Criteria for an expression that uses division

[Moxioron]

Hello.

I am trying to set a Criteria of >.50 for the expression below.

Available%: [Available]/[Credit Line Amount]

However, I get prompted for a parameter value.

I have saved the query and have even tried to build another query with this query as the source to no avail.

Is there something special I need to do in order to set Criteria for an expression with division? Thanks.

 

[MarkK]

You get this error if you use a fieldname that doesn't exist in any of the tables referenced by your query. Check your spellings. Check that the fields you cite, Available and [Credit Line Amount] exist in the tables that your query consumes.
Hope this helps,

 

[Moxioron]

Yes sir.

Something I forgot to mention. The query works great without the Criteria.

Once I populate the field though, I get the prompt.

 

[Alansidman]

Check the spelling in your expression and make sure it matches the field names you have in the expression. This is the usual reason for a parameter box in this situation. You have something listed as a field that Access cannot recognize. Spacing in the field name? A good reason to employCamelFormat. No spaces.

Edit: my turn to be slow :banghead:

 

[Moxioron]

Now I am getting the Overflow message..... bizarre.

 

[jdraw]

Please show us your table design as a jpg.
There is a spelling/formatting error as has been mentioned by Allan and Mark.

With any division, you have to be on the lookout for division by 0.