What's wrong with my formula?

K

Kaylen

EXPRESSION: IIf(DCount("*","Files","[14] IN ('Y','N') AND [Review Date]
=#")=0,"N/A",FormatPercent((DCount("*","Files","[14] ='Y' and [Review
Date]=#")/DCount("*","Files","[14] IN ('Y','N') and [Review Date]=#")),0))

I tried to run the formula in a query and i keep getting error message
saying syntax error in date in query expression. Can anyone help? Thank you.
 

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

Formula problem 1
What is wrong with this formula? Help! 2
Formula Wizard Anyone? 1
formula need a fix. HELP! 1
correct IIF function in query field 8
Help needed with IIF in my query 14
DCount function for filtered data in table 7
Query Formula need HELP 3

Top