Prevent redundant data in an SQL database

[rtshort]

I have a database to keep up with clients. If the client is already in the database, I want to add a number to the #Visits column when they enter their information. Their Phone # is the "primary key" so I need to compare that with the information entered on the form. If the Phone # exists in the database I need the #Visits column to be updated with one added to it. Like

.fields("#Visits&quot.value = .fields("#Visits&quot.value + 1

I'm using a reference to ADO 2.5 to open the connection.
How would I go about comparing the Phone# field in code to see if it already exists.

 

[Hackster]

This seems pretty straight forward. Create a recordset based on a SQL SELECT for Phone # WHERE Client = the client name you are looking for.

If the recordset.recordcount = 0 then the client does not exist. If it is equal to 1, then the client does exist.

 

[rtshort]

That's what I needed. Thanks Every day above ground is a GOOD DAY!!!