hoe to fined the count from fileds?

hi
i have table in database access
i need to fin the count from table1 faield = salary and show the count in text1

thank you:wave:

So you want to get the row count from the table where the field value = salary?
If so then...

Code:

---

SELECT Count(Field1) FROM Table1 WHERE Field1 = 'Salary'

---