DCount with And Syntax

burrina

Registered User.
Local time
Today, 16:49
Joined
May 10, 2014
Messages
972
Me.lblpaid.Visible = (DCount("*", "tblHour", "Hours Is Null") > 0 And [Paid] = "No")


Paid Date/Type is Yes/No and format Yes/No
 
Hello,
And like :
Me.lblpaid.Visible = (DCount("*", "tblHour", "[Hours]=Null") > 0 And [Paid] = "No")
 

Users who are viewing this thread

Back
Top Bottom