Search results

No. I am looking to filter down the results with the extra keywords. If this works though I might want a second query that does OR. Thanks.

I've been thinking about something and I wanted to run it past you since I don't have my database here with me today. Would it be possible to have an expression like this in the criteria section of my SortField that would prompt multiple times, but allow for multiple keywords to be applied to...

No. I think that requires a literal match, and shows only one record at a time. I am trying to find all matches and view them as a report.

Okay got it working with the Like expression. Here is what I have. I'm going to try creating the In() expression under the criteria and see what I get.

I must be doing something wrong. This crashed Access and I had to repair the database.

This is in the query itself, not the table? Correct?

I can't seem to get the In() operator to work, can you give me an example based on the quoted SQL above?

I'm confused. Looking at Office Online it seems like the In() operator won't work in my expression. Here is what I have at present. It promps multiple times and each prompt can take only one keyword. I have more fields to add to the search since this query was built, but it should give you an...

Sorry, I'm still a novice at this. Can you give me an example based on my example above? Thanks. -Alex

Is there any way to get the field to fill automatically, or does all the data need to be retyped into that field? Also that doesn't explain how to get multiple keywords into the query prompt. Right now I am using Like "*" & [ Field_Name ] & "*" to perform the search, but multiple keyword...

Is it possible to format a report in such a way that each record displayed links back to the main form (and that record)? In other words I want to click on a record in a report and be linked back to that record in the main data entry form. Any help would be appreciated. Thanks. -Alex

I hope I can explain what I am trying to do correctly. I have created a database for tracking a collection of plastic miniatures. The main table which stores all the data about the individual models has 11 - 13 fields I would like to seach with a single query. What I want is this... A single...

pbaldy, Thanks for all of your help. If you can think of a way I can enter one or more words into a single prompt and have it search across all five fields returning records where all of the keywords appear across any of the searched fields, please let me know. Thanks again!

I think I figured it out. The operator before the Keywords argument needs to be OR, instead of AND and I get the results I want. Still multiple prompts, but I think it will work the way I want it to.

Sorry, my database has 1063 records. Some of those meet the criteria.

I think what I want is actually more complex than what I explained. In fact looking to the top of the thread that is exactly the case. This works good for now, but I'd still like to be able to enter one or more words into a single prompt and have it search across all five fields returning...

Wait. Okay I think I see the problem. It works when only one prompt is answered, but if you answer more than one prompt it returns no records. I would like to be able to enter "human" in the Model Name prompt and "human" in the keyword prompt and get all records where "human" appears in either...

Here is what I have and I get no results.

I think I see. I'll give it a try.

Any suggestions yet? I have the db with me at work on my flash drive, so I can try things out.