How can I combine 2 expressions that use the DCount function?
For example, in control source,
=DCount("[Field1]","qryX","[Field1]=True") will give me a value Y which I
need to add to another value obtained by
=DCount("[Field1]",qryZ","[Field1]=True").
I have tried various bits such as =DCount("[Field1]","qryX" And
"qryZ","[Field1]=True") but that does not work.
Can anyone help?
Regards

Have you tried

=DCount("[Field1]","qryX","[Field1]=True") +
DCount("[Field1]",qryZ","[Field1]=True").


--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..

"LP" <(E-Mail Removed)> wrote in message
news:9196E721-6092-45AD-8642-(E-Mail Removed)...
> How can I combine 2 expressions that use the DCount function?
> For example, in control source,
> =DCount("[Field1]","qryX","[Field1]=True") will give me a value Y which I
> need to add to another value obtained by
> =DCount("[Field1]",qryZ","[Field1]=True").
> I have tried various bits such as =DCount("[Field1]","qryX" And
> "qryZ","[Field1]=True") but that does not work.
> Can anyone help?
> Regards

Many thanks for this John
Regards
LP

"John Spencer" wrote:

> Have you tried
>
> =DCount("[Field1]","qryX","[Field1]=True") +
> DCount("[Field1]",qryZ","[Field1]=True").
>
>
> --
> John Spencer
> Access MVP 2002-2005, 2007-2008
> Center for Health Program Development and Management
> University of Maryland Baltimore County
> ..
>
> "LP" <(E-Mail Removed)> wrote in message
> news:9196E721-6092-45AD-8642-(E-Mail Removed)...
> > How can I combine 2 expressions that use the DCount function?
> > For example, in control source,
> > =DCount("[Field1]","qryX","[Field1]=True") will give me a value Y which I
> > need to add to another value obtained by
> > =DCount("[Field1]",qryZ","[Field1]=True").
> > I have tried various bits such as =DCount("[Field1]","qryX" And
> > "qryZ","[Field1]=True") but that does not work.
> > Can anyone help?
> > Regards
>
>
>