IFF causing a prompt in a query

M

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
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Iff Statements 6
Iff Function 2
IFF statement 4
update query with iff 3
Null Criteria Problem 4
Alternative to compound IFF statement? 12
Subject: Need help on Iff Statement 1
Append Crosstab Query to Existing Table 0

Top