DCount Help on Subreport

[WPW07]

Hello,

I'm stuck with a Dcount function. I'm trying to count the number of
choices for a given event where the choice=1. This is in the EventID
footer of a subreport. This is what I have:

=DCount("[Choice]","qryEventChoices","[Choice]=1" And "[EventID] = " &
[EventID]).

EventID is a string.

It's returning ALL choices (4000) in the query instead of just those
with a value of 1 (27 for event A)

Thanks

 

[Klatuu]

Since EventID is a string, you need to correct the syntax:
=DCount("[Choice]","qryEventChoices","[Choice]=1" And "[EventID] = """ &
[EventID] & """").

 

[Douglas J. Steele]

Not only that, but the And needs to be inside the quotes:

=DCount("[Choice]","qryEventChoices","[Choice]=1 And [EventID] = """ &
[EventID] & """").


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Since EventID is a string, you need to correct the syntax:
=DCount("[Choice]","qryEventChoices","[Choice]=1" And "[EventID] = """ &
[EventID] & """").

--
Dave Hargis, Microsoft Access MVP

Hello,

I'm stuck with a Dcount function. I'm trying to count the number of
choices for a given event where the choice=1. This is in the EventID
footer of a subreport. This is what I have:

=DCount("[Choice]","qryEventChoices","[Choice]=1" And "[EventID] = " &
[EventID]).

EventID is a string.

It's returning ALL choices (4000) in the query instead of just those
with a value of 1 (27 for event A)

Thanks

 

[Klatuu]

Thanks, Doug
--
Dave Hargis, Microsoft Access MVP

Not only that, but the And needs to be inside the quotes:

=DCount("[Choice]","qryEventChoices","[Choice]=1 And [EventID] = """ &
[EventID] & """").


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Since EventID is a string, you need to correct the syntax:
=DCount("[Choice]","qryEventChoices","[Choice]=1" And "[EventID] = """ &
[EventID] & """").

--
Dave Hargis, Microsoft Access MVP

Hello,

I'm stuck with a Dcount function. I'm trying to count the number of
choices for a given event where the choice=1. This is in the EventID
footer of a subreport. This is what I have:

=DCount("[Choice]","qryEventChoices","[Choice]=1" And "[EventID] = " &
[EventID]).

EventID is a string.

It's returning ALL choices (4000) in the query instead of just those
with a value of 1 (27 for event A)

Thanks

 

[Marshall Barton]

Hello,

I'm stuck with a Dcount function. I'm trying to count the number of
choices for a given event where the choice=1. This is in the EventID
footer of a subreport. This is what I have:

=DCount("[Choice]","qryEventChoices","[Choice]=1" And "[EventID] = " &
[EventID]).

EventID is a string.

It's returning ALL choices (4000) in the query instead of just those
with a value of 1 (27 for event A)

Try something more like:

=DCount("Choice","qryEventChoices","Choice=1 And EventID='"
& EventID & "' ")

 

[WPW07]

Thank you for your help. That worked perfectly...

Hello,

I'm stuck with a Dcount function.  I'm trying to count the number of
choices for a given event where the choice=1.  This is in the EventID
footer of a subreport.  This is what I have:

=DCount("[Choice]","qryEventChoices","[Choice]=1" And "[EventID] =" &
[EventID]).

EventID is a string.

It's returning ALL choices (4000) in the query instead of just those
with a value of 1 (27 for event A)

Try something more like:

=DCount("Choice","qryEventChoices","Choice=1 And EventID='"
& EventID & "' ")