multiple user specified parameters for search query?

[shopoholic]

Hello

I have created a database for my department to log all of our jobs to keep track of them and I want to create a simple search for them but I am having difficulties.

I am familiar with creating queries to search tables for matching records, but is it possible to get search criteria from the user (ideally from a search form they fill in) to form the query?

For example, I would like the user to be able to query the jobs by month and/or business area and/or supplier...is this possible?

Any help gratefully received!!!

 

[klr397]

have you tried creating a form that would get the info froma user and then building a macro to search for the jobs?

 

[shopoholic]

Ok, thanks I will try that. Not too hot on macros though so might be back for help on that!