Like count on report header

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

KAnoe - 07 Jan 2005 17:41 GMT

I have a report that I would like to ldo a like count on. I'm using the
following code at the top of the form

=Abs(Sum([RSID]="1D1*"))
=Abs(Sum([RSID]=Like "1D1" & "*"))

And I could not get it to work.

Reply to this Message

fredg - 07 Jan 2005 18:07 GMT

> I have a report that I would like to ldo a like count on. I'm using the
> following code at the top of the form
[quoted text clipped - 3 lines]
>
> And I could not get it to work.

You were almost there.

=Abs(Sum([RSID] Like "1D1" & "*"))
or
=Abs(Sum([RSID] Like "1D1*" ))

Signature

Fred
Please only reply to this newsgroup.
I do not reply to personal email.

Reply to this Message

KAnoe - 07 Jan 2005 18:18 GMT

Thanks

> > I have a report that I would like to ldo a like count on. I'm using the
> > following code at the top of the form
[quoted text clipped - 9 lines]
> or
> =Abs(Sum([RSID] Like "1D1*" ))

Reply to this Message