Dcount on Form

[Guest]

Hi all,

I have a quick quesion I hope someone might have an answer to.

I am trying to a dcount on a form. I am trying to use criteria that uses two
different fields. I have never done it with two different criteria and can
not get it to work. Here is the code: =DCount("[event_id]","All Incoming
Students","[batch_status] = 'EXCH'" And "Attended = No")

Am I even close? Thanks in advance for your help!!

 

[Guest]

Try this

=DCount("[event_id]","All Incoming Students","[batch_status] = 'EXCH' AND
Attended = No")

If Attended is string type then
=DCount("[event_id]","All Incoming Students","[batch_status] = 'EXCH' AND
Attended = 'No'")

 

[Marshall Barton]

I have a quick quesion I hope someone might have an answer to.

I am trying to a dcount on a form. I am trying to use criteria that uses two
different fields. I have never done it with two different criteria and can
not get it to work. Here is the code: =DCount("[event_id]","All Incoming
Students","[batch_status] = 'EXCH'" And "Attended = No")

Am I even close? Thanks in advance for your help!!

Very close, just too many quotes. The And is part of the
criteria, not an operator to create the criteria string.

. . .,"[batch_status] = 'EXCH' And Attended = No")

 

[Guest]

Thanks everyone!! I think that did it. Thaks for the quick reply.
Bill