S sbaud2003 Member Local time Tomorrow, 03:46 Joined Apr 5, 2020 Messages 186 Feb 26, 2024 #1 Code is Cnt = Nz(DCount("*", "[INDIVIDUAL_DATA]", "[TXTGROUP] = GROUP_PRACTICAL And [TXTCODE] = COURSE_CODE")) both GROUP_PRACTICAL and COURSE_CODE are text field
Code is Cnt = Nz(DCount("*", "[INDIVIDUAL_DATA]", "[TXTGROUP] = GROUP_PRACTICAL And [TXTCODE] = COURSE_CODE")) both GROUP_PRACTICAL and COURSE_CODE are text field
arnelgp ..forever waiting... waiting for jellybean! Local time Tomorrow, 06:16 Joined May 7, 2009 Messages 20,361 Feb 26, 2024 #2 if both textfield are String: Cnt = DCount("*", "[INDIVIDUAL_DATA]", "[TXTGROUP] ='" & GROUP_PRACTICAL & "' And [TXTCODE] ='" & COURSE_CODE & "'")
if both textfield are String: Cnt = DCount("*", "[INDIVIDUAL_DATA]", "[TXTGROUP] ='" & GROUP_PRACTICAL & "' And [TXTCODE] ='" & COURSE_CODE & "'")
S sbaud2003 Member Local time Tomorrow, 03:46 Joined Apr 5, 2020 Messages 186 Feb 26, 2024 #3 arnelgp said: if both textfield are String: Cnt = DCount("*", "[INDIVIDUAL_DATA]", "[TXTGROUP] ='" & GROUP_PRACTICAL & "' And [TXTCODE] ='" & COURSE_CODE & "'") Click to expand... The output is coming (0 )zero
arnelgp said: if both textfield are String: Cnt = DCount("*", "[INDIVIDUAL_DATA]", "[TXTGROUP] ='" & GROUP_PRACTICAL & "' And [TXTCODE] ='" & COURSE_CODE & "'") Click to expand... The output is coming (0 )zero
arnelgp ..forever waiting... waiting for jellybean! Local time Tomorrow, 06:16 Joined May 7, 2009 Messages 20,361 Feb 26, 2024 #4 then i think it is reversed, your Fields are GROUP_PRACTICAL and COURSE_CODE? Cnt = DCount("*", "[INDIVIDUAL_DATA]", "GROUP_PRACTICAL ='" & [TXTGROUP] & "' And COURSE_CODE ='" & [TXTCODE] & "'")
then i think it is reversed, your Fields are GROUP_PRACTICAL and COURSE_CODE? Cnt = DCount("*", "[INDIVIDUAL_DATA]", "GROUP_PRACTICAL ='" & [TXTGROUP] & "' And COURSE_CODE ='" & [TXTCODE] & "'")
S sbaud2003 Member Local time Tomorrow, 03:46 Joined Apr 5, 2020 Messages 186 Feb 26, 2024 #5 arnelgp said: then i think it is reversed, your Fields are GROUP_PRACTICAL and COURSE_CODE? Cnt = DCount("*", "[INDIVIDUAL_DATA]", "GROUP_PRACTICAL ='" & [TXTGROUP] & "' And COURSE_CODE ='" & [TXTCODE] & "'") Click to expand... Yes, sir you are right, thank you so much. Loved the way you settle my problem
arnelgp said: then i think it is reversed, your Fields are GROUP_PRACTICAL and COURSE_CODE? Cnt = DCount("*", "[INDIVIDUAL_DATA]", "GROUP_PRACTICAL ='" & [TXTGROUP] & "' And COURSE_CODE ='" & [TXTCODE] & "'") Click to expand... Yes, sir you are right, thank you so much. Loved the way you settle my problem