Close on the count code

K

KAnoe

I need to count on the my RSID field. here is what im using.

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

Could not get it to work.

Any help would be great
 
M

Marshall Barton

KAnoe said:
I need to count on the my RSID field. here is what im using.

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


Any time you use wildcards in a comparison, you must use the
Like operator (without the = sign):

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