Count([Item]) From tblPHPDeveloperDoItems Where [Resolved] = True

I put the following

Count([Item]) From tblPHPDeveloperDoItems Where [Resolved] = True

in a report footer. It's OK at compile time. But when the report
runs - it gives me an error. Is there something I can do differently
to count up the number of records in the report where [Resolved]
is True?

Thx.

Re: Count([Item]) From tblPHPDeveloperDoItems Where [Resolved] = True

On Mon, 19 Nov 2007 18:38:41 -0500, MLH wrote:

>I put the following
>
>Count([Item]) From tblPHPDeveloperDoItems Where [Resolved] = True


I can do this...
=CStr(Count([Item])) & " Do-Items. " &
CStr(DCount("[Item]","tblPHPDeveloperDoItems","[Resolved] = True")) &
" Resolved Do-Items. "

But I was hoping to find out whether it could be done with Count
rather than DCount.

Re: Count([Item]) From tblPHPDeveloperDoItems Where [Resolved] = True

"MLH" wrote in message
news:vt74k3psv2gbmo6rlsf401eidkdaps6ftt@4ax.com...
> On Mon, 19 Nov 2007 18:38:41 -0500, MLH wrote:
>
>>I put the following
>>
>>Count([Item]) From tblPHPDeveloperDoItems Where [Resolved] = True
>
>
> I can do this...
> =CStr(Count([Item])) & " Do-Items. " &
> CStr(DCount("[Item]","tblPHPDeveloperDoItems","[Resolved] = True")) &
> " Resolved Do-Items. "
>
> But I was hoping to find out whether it could be done with Count
> rather than DCount.

It's not clear to me what you expected to do... nor details of what you
have. Also, what do you mean when you say "put the following . . . in the
Report Footer"? If you expect to execute an SQL statement from a Control
Source, that won't work. On the other hand, you can have a calculated
Control, wiht a Control Source including a DCount domain aggregate
statement, which can be executed. That may be why the second one worked.

If both the fields Item and Resolved are in Controls on your Report, you may
not have to resort to a DCount.

Larry Linson
Microsoft Access MVP

Re: Count([Item]) From tblPHPDeveloperDoItems Where [Resolved] = True

On Tue, 20 Nov 2007 04:37:09 GMT, "Larry Linson"
wrote:

>It's not clear to me what you expected to do... nor details of what you
>have. Also, what do you mean when you say "put the following . . . in the
>Report Footer"? If you expect to execute an SQL statement from a Control
>Source, that won't work. On the other hand, you can have a calculated
>Control, wiht a Control Source including a DCount domain aggregate
>statement, which can be executed. That may be why the second one worked.
>
>If both the fields Item and Resolved are in Controls on your Report, you may
>not have to resort to a DCount.
>
> Larry Linson
> Microsoft Access MVP
Thx, Larry. Both fields are in controls on the report. I'm still
working on it. Haven't got there yet. Small challenges are a
diversion for me. I enjoy them.