Complex query search with multi filter functions.

[Johntrevis]

Hello,
I currently work on an Database for an schoolprojekt.
In Germany -> So my „Access English“ ist not that good.


Our Database is a Database for recipes, with an complicated search option.


I try to give you an plane Example of how it (should) work.


We have some recipes like:


„Soup“
Ingrediens are: „potato“ „Clery“ „Leek“


„Potatosalad“
Ingrediens are: „Mayo“ „onion“ „potato“ „Bacon“


„Pancakes“
Ingrediens are: „Milk“ „Floar“ „Butter“


Far enough.


Now the Search I need help with.


In the Form the user should enter some Ingediens is has at home.
and the database returns the most Matching Recepies, in this Case:


We search for: „Potato“ „Plum“ „Leek“ „Clery“ „Bacon“


The Answer should then be:


„Soup“ (Match 3/3)
„Potatosalad“(Match 2/4)


Not the Pancakes because there is no match.


I hope you get the Idea

Im grateful for every little bit of helpful information!
If need i can send the databank to you.
Thank you!

 

[Micron]

Re: Komplex queary search with multi filter funktions.

Hi John; your English is far better than my German, so no apologies needed!
The answer depends on how your data is organized and how are you going to devise a list of ingredients to search for.
Hopefully, you are following database normalization principles and are not storing the ingredients in one table field. If you are keeping several ingredients in one field, it will require the use of something like the Instr function: MS Access: Instr Function

You would also need to tell us how you are creating a 'list' of ingredients to search by and how you want to use that list. It might be easier if you could make the database available to reduce the number of questions we'd have, but I for one would only advise since I did not do my children's homework either!

 

[Johntrevis]

Re: Komplex queary search with multi filter funktions.

Hey Micron,
Thank you for Answering!
Every Ingredient is unique and we connected it to the actual recipe with the ID. So there Are 3 TBL for that (You´ll see )
I Uploaded the DB on my DropBox. Its on German but You'll get the Idea.. I Titteld the queries for your understandment.
Thanks A lot https://www.dropbox.com/s/lc7asxss0egwxk5/forMicronTHX.accdb?dl=0

 

[Micron]

Re: Komplex queary search with multi filter funktions.

Perhaps you uploaded the wrong db? It's all in German and I can't read any of what I see in the navigation pane. Sorry...

 

[Micron]

BUMP: Re: Komplex queary search with multi filter funktions

Attempting to bump for OP. Aside from the fact that I can't read anything in the db, there are compatibility issues. This needs someone with newer version than 2007 who can read German.