Overflow Error Caused by Criteria

[kdbailey]

I have a calculated field Labeled [Hours/Month], simply enough, it is calculated by dividing one field [Hours] by the other field [Months].



The field calculates just fine as 0 or null values are not part of the data set. However, I am trying to write a query that parses this data where the calculation (Hours/Month) is greater than (750/36 or 20.83).

I would expect to just be able to plug ">750/36" into the criteria, but this gives an overflow error, as does ">20.83". I don't want to have to write this data set to a table before being able to add this simple criteria, can anybody tell me why this is happening?

[Bob Fitz]

Are actually using the quotes in the criteria. Try: >(750/36) or > 20.83

[kdbailey]

No quotes, I'm just clarifying with the quotes what's being put in there.

[Bob Fitz]

Can you post a copy of the db

[kdbailey]

It is sensitive information.

[Bob Fitz]

It is sensitive information.

How about a copy, with a little fictitious data, to illustrate the problem

[kdbailey]

I think I may have found the source of the issue.

I believe it had something to do with using the Max function for one of the fields. It is working at the moment.