Searching through access

[hysaccess]

Hello,

I am using Access.

I would just like to ask what is the simplest way to check if there is already a match in the table.

E.g.

I currently have a simple table containing a list of filenames.

and i just simply want to know whether a filename already exists in that table already..

 

[humbleprogrammer]

Do you want to accomplish this with a query that searches for a filename?

If so write your query like:

SELECT TableName.* FROM TableName WHERE (((TableName.filename)="name of your file&quot);