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

[MLH]

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.

[MLH]

On Mon, 19 Nov 2007 18:38:41 -0500, MLH <CR**@NorthState.netwrote:

>I put the following

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

<snip>

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.

[Larry Linson]

"MLH" <CR**@NorthState.netwrote in message
news:vt********************************@4ax.com...

On Mon, 19 Nov 2007 18:38:41 -0500, MLH <CR**@NorthState.netwrote:

>>I put the following

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

<snip>

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

[MLH]

On Tue, 20 Nov 2007 04:37:09 GMT, "Larry Linson"
<bo*****@localhost.notwrote:

>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.