Hi all,

I have created the following query:

SELECT *
FROM tbl_Jobs
WHERE job_title LIKE %MM_Keywords% AND location LIKE MM_Location AND job_type LIKE MM_JobType AND job_sector LIKE MM_JobSector AND salary LIKE MM_Salary

This works perfectly when the users select the "All"option with a value of %, but how can I get this query to show records between 2 values for the salary option? I am stuck! The database field for salary is numeric in access.

Thanks.

Strawberrysoup Website Design
www.strawberrysoup.co.uk

How would you actually go to do this?? I mean what would be the fields present to do the search?

It is for a recruitment website - so I want the search to give users the option of choosing jobs with a salary of (for example) between £20,000 and £30,000.

How is this possible?

Strawberrysoup Website Design
www.strawberrysoup.co.uk

Will the user have to enter in a textbox the values or will it be preset in a dropdown??

It is planned for the values to be in a dropdown.

Strawberrysoup Website Design
www.strawberrysoup.co.uk

Then create an id for each salary and use this in the where you store the salary details. And use that same id in the search value.