K
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!
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!