Solved Please rectify me (1 Viewer)

[sbaud2003]

Code is
Cnt = Nz(DCount("*", "[INDIVIDUAL_DATA]", "[TXTGROUP] = GROUP_PRACTICAL And [TXTCODE] = COURSE_CODE"))
both GROUP_PRACTICAL and COURSE_CODE are text field

 

[arnelgp]

if both textfield are String:

Cnt = DCount("*", "[INDIVIDUAL_DATA]", "[TXTGROUP] ='" & GROUP_PRACTICAL & "' And [TXTCODE] ='" & COURSE_CODE & "'")

 

[sbaud2003]

if both textfield are String:

Cnt = DCount("*", "[INDIVIDUAL_DATA]", "[TXTGROUP] ='" & GROUP_PRACTICAL & "' And [TXTCODE] ='" & COURSE_CODE & "'")

The output is coming (0 )zero

 

[arnelgp]

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] & "'")

 

[sbaud2003]

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] & "'")

Yes, sir you are right, thank you so much. Loved the way you settle my problem