Like count on report header

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

Guest

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.
 
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.
Click to expand...

You were almost there.

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

fredg said:
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.
Click to expand...

You were almost there.

=Abs(Sum([RSID] Like "1D1" & "*"))
or
=Abs(Sum([RSID] Like "1D1*" ))
Click to expand...
 
Back
Top