Query Works - Query with Criteria returns error

[lordrom]

I can run my query and retreive the results, however, when I try to add a criteria (col value >0.04) I get a Division By Zero message. I also get this when I try to sort on the same column.

Any ideas please?

Thanks in advance

 

[GinaWhipp]

in the the field that needs to contain a value (the one that generates the error) use...

MyField: Nz([FieldName],0)

...in the Field line in the query.

 

[lordrom]

i amended some input columns to remove the possibility of null values, and now can sort the column. however, when i try to enter a criteria it asks for a parameter for some other column.

any thoughts at all please?

 

[GinaWhipp]

What did you change it to? And the other column, is it by any chance calculated?

 

[lordrom]

I've changed it to many things.

I take it I cannot calculate a value/column and then use that value to recalculate another column?

I have removed all reference to values calculated within this query and now it works