dcount

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm creating a report where my control source is a query and, the field that
I want to do a dcount is a textbox which is calling a function. I have
receive result when I use table as a domain, but can I use queries as domain.
I'm using Access 2000
 
You can use a query as the domain in a domain aggregate function such as
DCount() and DSum(). The query can't be a parameter query.

It is most often unnecessary to use domain agg functions in reports and
generally slows down the performance un-necessarily.
 
-----Original Message-----
You can use a query as the domain in a domain aggregate function such as
DCount() and DSum(). The query can't be a parameter query.

It is most often unnecessary to use domain agg functions in reports and
generally slows down the performance un-necessarily.

--
Duane Hookom
MS Access MVP
--

"using dcount funt on a report text box." <using dcount funt on a report
text (e-mail address removed)> wrote in message
query and, the field
that use queries as
domain.


.
Duane,
Click to expand...
You mentioned dcount is slow, so what's my other
option? Thanks.
 
I don't know enough about your situation. I have seen many questions where
someone will use an expression like:
=DCount("*","qselReportQuery","Gender = 'F'")
If the report's record source is "qselReportQuery" then a much more
efficient solution would be to use:
=Sum(Abs(Gender="F"))
 
Back
Top