Formula problem

[Kaylen]

Anyone help and fix this formula in my query please?

T2: IIf(DCount("*","Files","[14] IN ('Y','N') AND [1]= “PN†AND [Review
Date] =#" & [Confirm Review Date] &
"#")=0,"N/A",FormatPercent((DCount("*","Files","[14] ='Y' AND [1]= “PN†AND
[Review Date]=#" & [Confirm Review Date] & "#")/DCount("*","Files","[14] IN
('Y','N') AND [1]= “PN†AND [Review Date]=#" & [Confirm Review Date] &
"#")),0))

I keep getting error that the expression you entered as a query parameter
produced this error: MS can't find the name "PN" you entered in the
expression.

Better if I dont need to put PN for [1] and just have the users type what
they want.
Any help is greatly appreciated!

 

[Boyd Trimmell aka HiTechCoach]

You are wrapping all the other strings with ' not "

Try changing the “PN†to 'PN' everywhere.