Close on the count code

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

Guest

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
 
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*"))
 
Back
Top