2 independent criteria
in [Queries]
|
Prev: Function is not availalbe in expressions in query expression error message (0/1)
Next: I require a query to count repairs by week
From: Rubem on 3 May 2010 21:17 Hi, I have a query with the following fields: Date, Part Number, description, etc.. I need a 2 criteria.. 1 for Date and 1 for Part Number and I want them to be independent. In another words, if I want only a report in a specific range I would enter the dates or if I just want a report with only the part number I would enter the part number or if I need a report with both data, I would enter both data. Any suggestion? Thank you for your help. Rubem
From: Allen Browne on 4 May 2010 00:11
Take a look at this article: Search criteria at: http://allenbrowne.com/ser-62.html It explains how to set up a form where the user can enter whichever criteria they want, and you build a filter string from only the boxes where they entered something. The filter can then be applied to a form or to a report. If you don't want to go that way, the last part of the article explains how to design the WHERE clause of the query so you can do the whole thing in a query if you must go that route. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Rubem" <Rubem(a)discussions.microsoft.com> wrote in message news:D6C82DBD-D5C9-402F-8D63-FF72BC566338(a)microsoft.com... > Hi, > > I have a query with the following fields: Date, Part Number, description, > etc.. > I need a 2 criteria.. 1 for Date and 1 for Part Number and I want them to > be > independent. In another words, if I want only a report in a specific > range I > would enter the dates or if I just want a report with only the part number > I > would enter the part number or if I need a report with both data, I would > enter both data. > > Any suggestion? > > Thank you for your help. > > Rubem |