calculate # of records that have a specific value

If you have a parent table related to the table in question, you can set up a custom summary field in the parent that summarizes the number of child records where = "x". I'm taking you literally. You will have an easier time of doing what you want this way. Then, you can pass the value back into the child table as a lookup field.