Search parameter

[bday]

I have a query that when opened, opens a dialog box to type in what I am searching for. The problem is that I need to type in exact value in order to retrieve the record. Ex, if a field contains "BS - Psychology" and i search for "Psychology" then I will not retrieve that record. I must search for "BS - Psychology". Then if I have several records that enter different values that are similar, such as "Psychology", "BS - PSY", or "Psy.", then I will have to do multiple searches. Is there a way to set the parameter to search for fields that "contains" whatever I type in the dialog box, or is there a better way to search?

 

[John Big Booty]

Perhaps the sample DB here may be of interest.

 

[bday]

That example is a bit extreme but did help a little. I found that if I type Like "*" & [Degree Type] & "*" in the "criteria" box for the column I want to search in then a dialog box will display and I can type what I need. Searching for "psy" returned records containing "psyshology" and "BS - Psychology". Now that I have a query to search for what I need, how can I get the returned records to display in a report that I have previously made not linked to the query?

 

[John Big Booty]

Why do you want to show the results of your query in an unrelated report

By the way as an alternative, why not select the course name from a Combo box and then use;

Forms!FormName!ComboName

in the criteria of your query, this will eliminate the possibility of a misspelled course name.

 

[bday]

I am building a database to hold all employees resumes. I have 6 tables; "Employees", "Awards", "Education", "Certifications", "Training" and "Experience". I have created a report that contains subreports for each table that allows me to print something that looks like an employee resume. Idealy, I would be able to do a full text search on the report for a word, and only employees that have that word anywhere in their resume would be returned allowing me to print resumes for only those people. Basically I want to be able to find the employees with the degree, certification, certain experience, award etc that I need at the time. I created a sample "education" query that will allow me to search for a certain word or group of letters and only those employees containing those letters are returned. Now I want to be able to print their resumes.