If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
2 independent criteria
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 |
#2
|
|||
|
|||
2 independent criteria
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" wrote in message news 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 |
Thread Tools | |
Display Modes | |
|
|