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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Like count on report header 2
Like Count 10
Update table with VBA 3
Report Header Sum 3
Section and Page numbering 0
Dlookup help!! 2
TransferText to make batch file, need help 5
Is there a more elegant way of doing this ?? 4

Top