Hi All,

I've got an access database with a table called 'forum' created within.

forum has three fields.

id
data
date

My question is : How do i create a search on my site that clients can use to locate information.

cheers
Steve

The simple way is to use an SQL SELECT Statement..

SELECT * FROM forum WHERE data LIKE %Search Query%

Obviously replace 'Search Query' with the user's search term in the code. You can build from there using a combo of ASP and SQL o make it as complex as you like

thanks very much. thats gr8