Counting on reports

[Robert Sykes]

Hello again, I have a report based on a query (qrynewmem) which displays all
the members that have joined in a given month, there are 2 types of members,
Circuit and Elite (memtype). At the top of the report I have text boxes to
count the total number of new members, and the number of members from each
type.

The total works fine, but the total for each membership type doesn't seem to
work, I just get the #Error as a result, I've put the following function
into the control source of two unbound fields:

=DCount("memtype","qrynewmem","memtype = 'Circuit' ")
=DCount("memtype","qrynewmem","memtype = 'Elite' ")

Anyone know what's up with this?

Thanks in advance.

--
Notice of Confidentiality:
This transmission contains information that may be confidential and that may
also be privileged. Unless you are the intended recipient of the message
(or authorized to receive it for the intended recipient), you may not copy,
forward, or otherwise use it, or disclose its contents to anyone else. If
you have received this transmission in error, please notify us immediately
and delete it from your system.

 

[Duane Hookom]

In the report header, you could use control sources of:
=Abs(Sum([memtype] = "Circuit"))
=Abs(Sum([memtype] = "Elite"))

 

[Robert Sykes]

Thank you

In the report header, you could use control sources of:
=Abs(Sum([memtype] = "Circuit"))
=Abs(Sum([memtype] = "Elite"))


--
Duane Hookom
MS Access MVP
--

Hello again, I have a report based on a query (qrynewmem) which displays
all
the members that have joined in a given month, there are 2 types of
members,
Circuit and Elite (memtype). At the top of the report I have text boxes to
count the total number of new members, and the number of members from each
type.

The total works fine, but the total for each membership type doesn't seem
to
work, I just get the #Error as a result, I've put the following function
into the control source of two unbound fields:

=DCount("memtype","qrynewmem","memtype = 'Circuit' ")
=DCount("memtype","qrynewmem","memtype = 'Elite' ")

Anyone know what's up with this?

Thanks in advance.

--
Notice of Confidentiality:
This transmission contains information that may be confidential and that
may
also be privileged. Unless you are the intended recipient of the message
(or authorized to receive it for the intended recipient), you may not
copy,
forward, or otherwise use it, or disclose its contents to anyone else. If
you have received this transmission in error, please notify us immediately
and delete it from your system.