Overflow from Criteria

[thesmug1]

Hey all,



So I'm using the following query:

Avg_Prem_Group_Ind: IIf([earn_prem_ind]/[mm_ind]<208.33,"<$208.33","$208.33+")

I would like to pull only rows that contain <$208.33, so I use the following criteria:

="<$208.33"

When I run the query, all I get is the overflow message. I am new to access, so any help would be greatly appreciated.

[ketbdnetbp]

If I understand your post correctly, then -

I would change this:

Avg_Prem_Group_Ind: IIf([earn_prem_ind]/[mm_ind]<208.33,"<$208.33","$208.33+")

to:

Avg_Prem_Group_Ind: [earn_prem_ind]/[mm_ind]

and the criteria to:
<=208.33

Hope this helps,

Jim

[thesmug1]

Jim,

I tried that, and I am still getting the overflow. I also double checked that there are no 0s in the [mm_ind] field. Do you know what else could be causing this? Thanks for your help thus far.

[ketbdnetbp]

Don't know off the top of my head. Can you post a copy of the db for analysis? Strip the db of any sensitive data then do a Compact and repair.

Jim

[rpeare]

I suspect you're probably using a totals query (clicking the Sigma button on the toolbar and getting a totals line) and just not correctly accounting for it. I can not re-create your error to say for sure.