Search results

I have a table that may contain 2 or more records for certain account numbers. I added a field called Account Count that I want to do an update query for populating it similarly to excel's countif. I simply want to count how many times that account number is in the table. So if for instance...