Search the Table for spacific name and count duplicates

Question

Dear Users

 

I have problem with this:

 

I have a TextBox and a Button in my Form1. ( my data base is Access 2003 ).

 

 

I want to:  Button when Clicked, it search for Example "employers" table and find what the user typed in TextBox.

 

For example: I typed "John Jobs" in TextBox, I want the button to search the Table "Employers" for a field with that name. and it my also there are duplicate data and it found 2 same data for "john jobs" so it count them and show them in message box:

 

Messagebox.Show("there are  (????)  "jon jobs" in your data Base" );

 

thank you