Counting specific rows in a table

[bscs1963]

I am trying to count the number of rows in a table where a certain value is present.

I have a table that is populated and Field3 is a unique vlaue. The value "LI" can be in the table more than once in the same field, and I want to find out how many rows have the value "LI" in the table.

Then I can declare the value and use it later in the code.

 

[MajP]

http://msdn.microsoft.com/en-us/library/aa211471(v=office.11).aspx

 

[bscs1963]

Thanks!

That was perfect. I was missing the criteria section