multiple query form

  • Thread starter Thread starter k4an611
  • Start date Start date
K

k4an611

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

You may be missing the fact that a query can have *HUNDREDS* of
criteria; it's not limited to one criterion.

I suspect that you may find the "Query By Form" technique useful. If
you have a form displaying the fields you want to search by and see,
try selecting Records... Filter... Filter by Form from the menu.

You can also create a more automated parameter query to do this, but
you do *not* need to have separate queries for Color and for Shape and
so on!
 
Back
Top