"Dynamic query"

  • Thread starter Thread starter jim012
  • Start date Start date
J

jim012

Guest
Hello, i need a solution. I have a table with product codes (lines) and
many characteristics (rows)(e.g. diameter 30, typa a, finishing a) . I can have diferent reports by creating as many different queries as the number of characteristics are. But this is not handy to use.

What i need is a query form where i can enter e.g. for the characteristic No1 :"diameter 30". for the characteristic No2: "All", and for the
characteristic No3: "Finishing a", and get the desired list.

How can i do it In access 2000? Thank u
 

Users who are viewing this thread

Back
Top Bottom