Search results

My apologies for the confusion. The code was listed in original post. Here it is again: SELECT [00STUDENT INFORMATION].[Other ID], [00STUDENT INFORMATION].[Student Last Name], [00STUDENT INFORMATION].[Student First Name], IIf([PASSAGE# ] Is Null,0,[PASSAGE# ]) AS [COURSE PASSAGE#]...

Used the Nz formula and still getting wrong result. Scratching my head over this.

Still not working, :(

Please see below for code and screenshot. Thx

SELECT [00STUDENT INFORMATION].[Other ID], [00STUDENT INFORMATION].[Student Last Name], [00STUDENT INFORMATION].[Student First Name], IIf([PASSAGE# ] Is Null,0,[PASSAGE# ]) AS [COURSE PASSAGE#], IIf([FAILURE#- ESSA] Is Null,0,[FAILURE#- ESSA]) AS [COURES FAILURE#- ESSA], IIf([PASSAGE#]<5 Or...

Thank you for your reply. This query works every time except when Passage# is 0. If Passage# is 4,3,2, or 1 I get correct result. I think the 0 is throwing the formula off. Is there something I need to do for the 0 to get the correct result?

Have query: ESSA On Track: IIf([PASSAGE#]<5 Or [FAILURE#- ESSA]>1,"No","Yes") But when [PASSAGE#] is 0, I get Yes. What am I missing? Thx Team!