IFF causing a prompt in a query

[Mike]

I have a query that I added the following using the Builder in the field
name. Each time I run the query, it prompts me for the data in the data
fields used in the IFF statement.

Expr1:
Round(IIf([SumOfMT_Completion]=0,0,([SumOfMT_Completion]/[SumOfMT_Population])*100),2)

I just need to know what to do to stop the prompt.

Thanks in advance

 

[John Spencer (MVP)]

Post the entire query.

I suspect that SumOfMT_Completion is being calculated in the query and
therefore is not available. You might need something more like the following

Round(IIF(Sum(MT_Completion)=0,0,Sum(MT_Completion)/Sum(MT_Population))*100,2)

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County