slhangen's latest activity
-
Sslhangen replied to the thread Query result wrong when field is 0.My apologies for the confusion. The code was listed in original post. Here it is again: SELECT [00STUDENT INFORMATION].[Other ID]...
-
Sslhangen replied to the thread Query result wrong when field is 0.
-
Sslhangen replied to the thread Query result wrong when field is 0.Used the Nz formula and still getting wrong result. Scratching my head over this.
-
Sslhangen replied to the thread Query result wrong when field is 0.Still not working, :(
-
Sslhangen replied to the thread Query result wrong when field is 0.Please see below for code and screenshot. Thx
-
Sslhangen replied to the thread Query result wrong when field is 0.SELECT [00STUDENT INFORMATION].[Other ID], [00STUDENT INFORMATION].[Student Last Name], [00STUDENT INFORMATION].[Student First Name]...
-
-
Sslhangen replied to the thread Query result wrong when field is 0.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...
-
SHave 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...
