SELECT * FROM "vacancy_list Query"
WHERE Job_locator LIKE '::Job_locator::'

However, there is a second search criteria in the same form which is meant to limit the search to jobs posted in the last 1,2,3,4 or 5 days. I've got an automatic date stamp in the DB as to when each job was added. Can anyone tell me how to amend the above code to include this part of the filter? At the moment it does nothing, of course, because that code is only picking up the 'job locator' part of the form.

If it's any help, you can see the partially completed site at www.vbcontracts.com

Thanks in advance...

------------------
***born to be wild***

I think the following should work for you, please note that I have made up field names for those that you did not list, you will need to replace them with your actual field names, ie. Date_Posted is you date stamp field in your database and '::Days::' is the name of the form field being sent by the form.

SELECT * FROM "vacancy_list Query"
WHERE Job_locator LIKE '::Job_locator::' AND (Date_Posted => Date()-'::Days::')

I did this a little quickly but it should be close....

Keith