multiple queries form

[KellyNewUser]

I am new to access and I am trying to create a form to identify a medication by the color, shape, active ingredients, etc. I can create a query for the color and shape individually, but I want them to be all on one form. I want all queries that are answered to combine their information to create a list of possible medications. Any help would be appreciated. Let me know if this isn't making any sense. Thanks.

 

[BNPMike]

You can put several queries on to a form. A simple example is to drop queries in datasheet view onto your form side-by-side.

Connecting them is a bit more complex, but presumably you want something that merges these sources perhaps weighting the matches in some way.

 

[dhookom]

Usually with a question like this, you should provide some requirements, sample data, and sample output/display. It is very difficult and sometimes fruitless to provide answers and WAGs when we don't understand what you are asking for.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[BNPMike]

What's a WAG, Duane?

 

[dhookom]

Wild A** Guess.
Something that is used much too often when responding to questions in these fora.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[Golom]

Since we're all really technical here ...

It should not be SWAG? ... Scientific WAG!!