Solved Getting 0 (zero) for any Value in the Member_FK filed

[sbaud2003]

Txtissued.Value= DCount ("[LOAN_ID]", "[LOAN]", [Member_FK] = "Forms!FrmLoan!Member_FK" & " AND (Date_Returned) is Null")


can any one explain

 

[theDBguy]

Maybe try,

Txtissued.Value= DCount ("[LOAN_ID]", "[LOAN]", "[Member_FK] = " & Forms!FrmLoan!Member_FK & " AND (Date_Returned) is Null")

 

[sbaud2003]

Maybe try,

Txtissued.Value= DCount ("[LOAN_ID]", "[LOAN]", "[Member_FK] = " & Forms!FrmLoan!Member_FK & " AND (Date_Returned) is Null")

datatype mismatch error is coming

 

[theDBguy]

datatype mismatch error is coming

Then maybe try:

Txtissued.Value= DCount ("[LOAN_ID]", "[LOAN]", "[Member_FK] = '" & Forms!FrmLoan!Member_FK & "' AND (Date_Returned) is Null")

 

[The_Doc_Man]

When a DCount finds nothing, it returns zero. Therefore, your criteria statement must have been incorrectly formed. DBG showed you a way that should work, but for future reference, it is always a good idea to try to write a test query (using a constant rather than a form reference) to see if anything exists to match your criteria. That makes it easier to then build the DCount statement.

 

[sbaud2003]

T

DCount ("[LOAN_ID]", "[LOAN]", "[Member_FK] = '" & Forms!FrmLoan!Member_FK & "' AND (Date_Returned) is Null")

Thank you so much;;;;;
its working fine
I am really happy to be the member of This gruop
Thanks DBG

 

[theDBguy]

T

Thank you so much;;;;;
its working fine
I am really happy to be the member of This gruop
Thanks DBG

Hi. You're welcome. Doc and I were happy to assist. Good luck with your project.