title: how to count with condition in VFP?
body: <p>I am trying to count with condition in VFP.I am not trying to select anything, so I don't think I could use count here(correct me if i am wrong).</p>
  
  <p>I used reccount() to count number of rows in my table, but I need to add a condition with reccount(), 
  for example, I want to count rows with condition itemid=counter1, where itemid has repeated numbers in it, but counter1 is a counter I set up initially. So I want to count how many itemid=1 there are, and so on.
  Would my statement be similar to</p>
  
  <pre><code>RECCOUNT() where itemid=counter1
  </code></pre>
  
  <p>In manual of VFP, it seems like reccount cannot go with any conditions. I couldn't find any other ways to count with condition without the select command. Could anyone give some suggestions?</p>