query both search box and combo box

[robina]

I have a select query that runs nicely based on the criteria chosen on a form. My problem is that I have 4 combo boxes as criteria and on textbox (used as keyword search) and I can only get the query to return records for either any of the combo boxes or just the text box. I have [Forms]![name of form]![combo name] OR [Forms]![name of form]![combo name] IS NULL in the criteria row of the query in each applicable field, that works great, but I think I'm adding Like "*" & [Forms]![Search]![txtKeyword] & "*" for the textbox (search box) in several other fields incorrectly. I lose it when I'm trying to say "return results where field "A" is [Forms]![name of form]![combo name] OR [Forms]![name of form]![combo name] IS NULL OR field "B" is Like "*" & [Forms]![Search]![txtKeyword] & "*" OR Field "C" is [Forms]![name of form]![combo2 name] OR [Forms]![name of form]![combo name] IS NUL.

I hope this makes sense. And thank you.

 

[Brianwarnock]

You don't say what happens and what should happen, too many or no records , those with th A criteria but not the B criteria ?

It might help if you could copy and paste the Where clause from the SQL view.

Brian

 

[Brianwarnock]

You might also like to see my answer on this thread to see if it is relevent to the way you have coded your Like statement, leaving out the
And [Forms]![Search]![txtKeyword] is Not Null part means that if nothing is entered in that parameter all records are selected.

http://www.access-programmers.co.uk/forums/showthread.php?t=240855


Brian

 

[robina]

Brian,
Thank you for your quick response! I used some of your code from your posting. That is what gave me results for a keyword search (thank you). But I can't get both the dropdown and keyword search. If I make a selection from a combo box the criteria is ignored and all records are returned. If a keyword is entered, the correct results are returned. The SQL was overwhelmingly long so I've attached the databse. It is in access 2010 but should work with 2007 without a problem.

 

[Brianwarnock]

Unfortunately my system is like me, antiquated, I need an mdb as I am pre 2007

Brian

 

[robina]

okay Brian,
Give this a try...

 

[Brianwarnock]

Hi
after much effort, wow what a where clause, I have come to the conclusion that the flexibility that you have built into the top half of the form is what is causing the problem when the keyword search in the lower half is added.

The only solution I can think of is to have two queries, fired by separate command buttons on the upper and lower sections of the Form, and of course I do not know what problems this may cause you down the line, two reports probably.

BTW Why Access cannot leave a simple criteria such as

Forms!formname!cboname or Forms!formname!cboname is null

alone in the column instead of creating the chaos it does I don't know. I code that type of criteria directly into SQL and avoid going back into the Design Grid, but you only need to forget once.

Sorry that I cannot help more.

Brian

 

[Brianwarnock]

If you can add to the Combos a value that does not exist eg ANY then it will all work as I think you want it to if you change your Where clause to this

WHERE (((Contracts.Description) Like "*" & [Forms]![Search]![txtKeyword] & "*") AND (([Forms]![Search]![txtKeyword]) Is Not Null)) OR (((Contracts.Contract_Status)=[Forms]![Search]![CboStatus]) AND ((Contracts.Primary_Vendor_Name)=[Forms]![Search]![CboVend]) AND ((Dept_info.COE)=[Forms]![Search]![CboCOE]) AND ((Contracts.Dept_Desc_Acct)=[Forms]![Search]![CboDepDesc]) AND ((DateAdd("d",-[Termination_Notice_Req],DateAdd("m",[Contracts]![Initial_term_months],[Contracts]![Effective_Date])))=[Forms]![Search]![txtTermDate])) OR (((Contracts.Primary_Vendor_Name)=[Forms]![Search]![CboVend]) AND ((Dept_info.COE)=[Forms]![Search]![CboCOE]) AND ((Contracts.Dept_Desc_Acct)=[Forms]![Search]![CboDepDesc]) AND ((DateAdd("d",-[Termination_Notice_Req],DateAdd("m",[Contracts]![Initial_term_months],[Contracts]![Effective_Date])))=[Forms]![Search]![txtTermDate]) AND (([Forms]![Search]![CboStatus]) Is Null)) OR (((Contracts.Contract_Status)=[Forms]![Search]![CboStatus]) AND ((Dept_info.COE)=[Forms]![Search]![CboCOE]) AND ((Contracts.Dept_Desc_Acct)=[Forms]![Search]![CboDepDesc]) AND ((DateAdd("d",-[Termination_Notice_Req],DateAdd("m",[Contracts]![Initial_term_months],[Contracts]![Effective_Date])))=[Forms]![Search]![txtTermDate]) AND (([Forms]![Search]![CboVend]) Is Null)) OR (((Dept_info.COE)=[Forms]![Search]![CboCOE]) AND ((Contracts.Dept_Desc_Acct)=[Forms]![Search]![CboDepDesc]) AND ((DateAdd("d",-[Termination_Notice_Req],DateAdd("m",[Contracts]![Initial_term_months],[Contracts]![Effective_Date])))=[Forms]![Search]![txtTermDate]) AND (([Forms]![Search]![CboStatus]) Is Null) AND (([Forms]![Search]![CboVend]) Is Null)) OR (((Contracts.Contract_Status)=[Forms]![Search]![CboStatus]) AND ((Contracts.Primary_Vendor_Name)=[Forms]![Search]![CboVend]) AND ((Contracts.Dept_Desc_Acct)=[Forms]![Search]![CboDepDesc]) AND ((DateAdd("d",-[Termination_Notice_Req],DateAdd("m",[Contracts]![Initial_term_months],[Contracts]![Effective_Date])))=[Forms]![Search]![txtTermDate]) AND (([Forms]![Search]![CboCOE]) Is Null)) OR (((Contracts.Primary_Vendor_Name)=[Forms]![Search]![CboVend]) AND ((Contracts.Dept_Desc_Acct)=[Forms]![Search]![CboDepDesc]) AND ((DateAdd("d",-[Termination_Notice_Req],DateAdd("m",[Contracts]![Initial_term_months],[Contracts]![Effective_Date])))=[Forms]![Search]![txtTermDate]) AND (([Forms]![Search]![CboStatus]) Is Null) AND (([Forms]![Search]![CboCOE]) Is Null)) OR (((Contracts.Contract_Status)=[Forms]![Search]![CboStatus]) AND ((Contracts.Dept_Desc_Acct)=[Forms]![Search]![CboDepDesc]) AND ((DateAdd("d",-[Termination_Notice_Req],DateAdd("m",[Contracts]![Initial_term_months],[Contracts]![Effective_Date])))=[Forms]![Search]![txtTermDate]) AND (([Forms]![Search]![CboVend]) Is Null) AND (([Forms]![Search]![CboCOE]) Is Null)) OR (((Contracts.Dept_Desc_Acct)=[Forms]![Search]![CboDepDesc]) AND ((DateAdd("d",-[Termination_Notice_Req],DateAdd("m",[Contracts]![Initial_term_months],[Contracts]![Effective_Date])))=[Forms]![Search]![txtTermDate]) AND (([Forms]![Search]![CboStatus]) Is Null) AND (([Forms]![Search]![CboVend]) Is Null) AND (([Forms]![Search]![CboCOE]) Is Null)) OR (((Contracts.Contract_Status)=[Forms]![Search]![CboStatus]) AND ((Contracts.Primary_Vendor_Name)=[Forms]![Search]![CboVend]) AND ((Dept_info.COE)=[Forms]![Search]![CboCOE]) AND ((DateAdd("d",-[Termination_Notice_Req],DateAdd("m",[Contracts]![Initial_term_months],[Contracts]![Effective_Date])))=[Forms]![Search]![txtTermDate]) AND (([Forms]![Search]![CboCOE]) Is Null)) OR (((Contracts.Primary_Vendor_Name)=[Forms]![Search]![CboVend]) AND ((Dept_info.COE)=[Forms]![Search]![CboCOE]) AND ((DateAdd("d",-[Termination_Notice_Req],DateAdd("m",[Contracts]![Initial_term_months],[Contracts]![Effective_Date])))=[Forms]![Search]![txtTermDate]) AND (([Forms]![Search]![CboStatus]) Is Null) AND (([Forms]![Search]![CboCOE]) Is Null)) OR (((Contracts.Contract_Status)=[Forms]![Search]![CboStatus]) AND ((Dept_info.COE)=[Forms]![Search]![CboCOE]) AND ((DateAdd("d",-[Termination_Notice_Req],DateAdd("m",[Contracts]![Initial_term_months],[Contracts]![Effective_Date])))=[Forms]![Search]![txtTermDate]) AND (([Forms]![Search]![CboVend]) Is Null) AND (([Forms]![Search]![CboCOE]) Is Null)) OR (((Dept_info.COE)=[Forms]![Search]![CboCOE]) AND ((DateAdd("d",-[Termination_Notice_Req],DateAdd("m",[Contracts]![Initial_term_months],[Contracts]![Effective_Date])))=[Forms]![Search]![txtTermDate]) AND (([Forms]![Search]![CboStatus]) Is Null) AND (([Forms]![Search]![CboVend]) Is Null) AND (([Forms]![Search]![CboCOE]) Is Null)) OR (((Contracts.Contract_Status)=[Forms]![Search]![CboStatus]) AND ((Contracts.Primary_Vendor_Name)=[Forms]![Search]![CboVend]) AND ((DateAdd("d",-[Termination_Notice_Req],DateAdd("m",[Contracts]![Initial_term_months],[Contracts]![Effective_Date])))=[Forms]![Search]![txtTermDate]) AND (([Forms]![Search]![CboCOE]) Is Null And ([Forms]![Search]![CboCOE]) Is Null)) OR (((Contracts.Primary_Vendor_Name)=[Forms]![Search]![CboVend]) AND ((DateAdd("d",-[Termination_Notice_Req],DateAdd("m",[Contracts]![Initial_term_months],[Contracts]![Effective_Date])))=[Forms]![Search]![txtTermDate]) AND (([Forms]![Search]![CboStatus]) Is Null) AND (([Forms]![Search]![CboCOE]) Is Null And ([Forms]![Search]![CboCOE]) Is Null)) OR (((Contracts.Contract_Status)=[Forms]![Search]![CboStatus]) AND ((DateAdd("d",-[Termination_Notice_Req],DateAdd("m",[Contracts]![Initial_term_months],[Contracts]![Effective_Date])))=[Forms]![Search]![txtTermDate]) AND (([Forms]![Search]![CboVend]) Is Null) AND (([Forms]![Search]![CboCOE]) Is Null And ([Forms]![Search]![CboCOE]) Is Null)) OR (((DateAdd("d",-[Termination_Notice_Req],DateAdd("m",[Contracts]![Initial_term_months],[Contracts]![Effective_Date])))=[Forms]![Search]![txtTermDate]) AND (([Forms]![Search]![CboStatus]) Is Null) AND (([Forms]![Search]![CboVend]) Is Null) AND (([Forms]![Search]![CboCOE]) Is Null And ([Forms]![Search]![CboCOE]) Is Null)) OR (((Contracts.Contract_Status)=[Forms]![Search]![CboStatus]) AND ((Contracts.Primary_Vendor_Name)=[Forms]![Search]![CboVend]) AND ((Dept_info.COE)=[Forms]![Search]![CboCOE]) AND ((Contracts.Dept_Desc_Acct)=[Forms]![Search]![CboDepDesc]) AND (([Forms]![Search]![txtTermDate]) Is Null)) OR (((Contracts.Primary_Vendor_Name)=[Forms]![Search]![CboVend]) AND ((Dept_info.COE)=[Forms]![Search]![CboCOE]) AND ((Contracts.Dept_Desc_Acct)=[Forms]![Search]![CboDepDesc]) AND (([Forms]![Search]![CboStatus]) Is Null) AND (([Forms]![Search]![txtTermDate]) Is Null)) OR (((Contracts.Contract_Status)=[Forms]![Search]![CboStatus]) AND ((Dept_info.COE)=[Forms]![Search]![CboCOE]) AND ((Contracts.Dept_Desc_Acct)=[Forms]![Search]![CboDepDesc]) AND (([Forms]![Search]![CboVend]) Is Null) AND (([Forms]![Search]![txtTermDate]) Is Null)) OR (((Dept_info.COE)=[Forms]![Search]![CboCOE]) AND ((Contracts.Dept_Desc_Acct)=[Forms]![Search]![CboDepDesc]) AND (([Forms]![Search]![CboStatus]) Is Null) AND (([Forms]![Search]![CboVend]) Is Null) AND (([Forms]![Search]![txtTermDate]) Is Null)) OR (((Contracts.Contract_Status)=[Forms]![Search]![CboStatus]) AND ((Contracts.Primary_Vendor_Name)=[Forms]![Search]![CboVend]) AND ((Contracts.Dept_Desc_Acct)=[Forms]![Search]![CboDepDesc]) AND (([Forms]![Search]![CboCOE]) Is Null) AND (([Forms]![Search]![txtTermDate]) Is Null)) OR (((Contracts.Primary_Vendor_Name)=[Forms]![Search]![CboVend]) AND ((Contracts.Dept_Desc_Acct)=[Forms]![Search]![CboDepDesc]) AND (([Forms]![Search]![CboStatus]) Is Null) AND (([Forms]![Search]![CboCOE]) Is Null) AND (([Forms]![Search]![txtTermDate]) Is Null)) OR (((Contracts.Contract_Status)=[Forms]![Search]![CboStatus]) AND ((Contracts.Dept_Desc_Acct)=[Forms]![Search]![CboDepDesc]) AND (([Forms]![Search]![CboVend]) Is Null) AND (([Forms]![Search]![CboCOE]) Is Null) AND (([Forms]![Search]![txtTermDate]) Is Null)) OR (((Contracts.Dept_Desc_Acct)=[Forms]![Search]![CboDepDesc]) AND (([Forms]![Search]![CboStatus]) Is Null) AND (([Forms]![Search]![CboVend]) Is Null) AND (([Forms]![Search]![CboCOE]) Is Null) AND (([Forms]![Search]![txtTermDate]) Is Null)) OR (((Contracts.Contract_Status)=[Forms]![Search]![CboStatus]) AND ((Contracts.Primary_Vendor_Name)=[Forms]![Search]![CboVend]) AND ((Dept_info.COE)=[Forms]![Search]![CboCOE]) AND (([Forms]![Search]![CboCOE]) Is Null) AND (([Forms]![Search]![txtTermDate]) Is Null)) OR (((Contracts.Primary_Vendor_Name)=[Forms]![Search]![CboVend]) AND ((Dept_info.COE)=[Forms]![Search]![CboCOE]) AND (([Forms]![Search]![CboStatus]) Is Null) AND (([Forms]![Search]![CboCOE]) Is Null) AND (([Forms]![Search]![txtTermDate]) Is Null)) OR (((Contracts.Contract_Status)=[Forms]![Search]![CboStatus]) AND ((Dept_info.COE)=[Forms]![Search]![CboCOE]) AND (([Forms]![Search]![CboVend]) Is Null) AND (([Forms]![Search]![CboCOE]) Is Null) AND (([Forms]![Search]![txtTermDate]) Is Null)) OR (((Dept_info.COE)=[Forms]![Search]![CboCOE]) AND (([Forms]![Search]![CboStatus]) Is Null) AND (([Forms]![Search]![CboVend]) Is Null) AND (([Forms]![Search]![CboCOE]) Is Null) AND (([Forms]![Search]![txtTermDate]) Is Null)) OR (((Contracts.Contract_Status)=[Forms]![Search]![CboStatus]) AND ((Contracts.Primary_Vendor_Name)=[Forms]![Search]![CboVend]) AND (([Forms]![Search]![CboCOE]) Is Null And ([Forms]![Search]![CboCOE]) Is Null) AND (([Forms]![Search]![txtTermDate]) Is Null)) OR (((Contracts.Primary_Vendor_Name)=[Forms]![Search]![CboVend]) AND (([Forms]![Search]![CboStatus]) Is Null) AND (([Forms]![Search]![CboCOE]) Is Null And ([Forms]![Search]![CboCOE]) Is Null) AND (([Forms]![Search]![txtTermDate]) Is Null)) OR (((Contracts.Contract_Status)=[Forms]![Search]![CboStatus]) AND (([Forms]![Search]![CboVend]) Is Null) AND (([Forms]![Search]![CboCOE]) Is Null And ([Forms]![Search]![CboCOE]) Is Null) AND (([Forms]![Search]![txtTermDate]) Is Null)) OR ((([Forms]![Search]![CboStatus]) Is Null) AND (([Forms]![Search]![CboVend]) Is Null) AND (([Forms]![Search]![CboCOE]) Is Null And ([Forms]![Search]![CboCOE]) Is Null) AND (([Forms]![Search]![txtTermDate]) Is Null));

Best to create a copy of your query and replace the where clause with this one and by renaminfg the queries run your tests.

Essentially what I have done is separate the Like clause on its own criteria row so that it is never Anded with the other criteria, however if they are Null , which you need for your search flexibility, then all records are selected , hence the need for a value that cannot be met.

Brian

 

[robina]

Brian,
I appreciate all you effort. I used your code and while it does work now if i choose from the drop down, it returns all records when using the keyword search. I think I'll take your first suggestion and add an extra button to a second query. again, many thanks.

Robin

 

[Brianwarnock]

Well that is a simple straight foreward way, but it is not difficult to add <ANY> to the start of all your combos, it just requires the use of a simple Union query for instance the rowsource of cbovend would change to

SELECT DISTINCT vendor.Vendor_Name FROM vendor union select ' <ANY> ' from vendor ORDER BY vendor.Vendor_Name;

But the users would probably find it simpler to use the correct button than to select <ANY> in all of the combos.

Brian

 

[Brianwarnock]

I went to bed disgruntled with not having come up with a solution, but at 3:50 AM I awoke with a eureka moment. I have tested the code below except for the effective date bit and it allows

1 any combination of combos
2 no combos and keyword
3 any combos and keyword

the keyword can be in any of the fields searched.

Note If you make any changes save in SQL view to demonstrate what happens if you make a change and save in design view I have poste the SQL having removed the like on effective date.

Here is what works, I think

SELECT Contracts.Contract_ID, Contracts.Contract_Status, Contracts.Primary_Vendor_Name, Contracts.Start_Date, Contracts.Contract_Type, Contracts.Contract_Category, Contracts.Description, Contracts.Neg_Contract_Value, Contracts.Initial_Contract_Value, Dept_info.COE, Contracts.Department, Contracts.Dept_Desc_Acct, Contracts.[Multi-Party], Contracts.Original_ext_party, Contracts.[Term Type], Contracts.Effective_Date, Contracts.Initial_term_months, Contracts.[Auto-Renewal_Term], Contracts.Auto_Renewal_Notification_Period, Contracts.Renewed, Contracts.Termination_Convenience, Contracts.Termination_Notice_Req, (DateAdd("m",[Contracts]![Initial_term_months],[Contracts]![Effective_Date])) AS [Expiration Date], DateAdd("d",-[Termination_Notice_Req],DateAdd("m",[Contracts]![Initial_term_months],[Contracts]![Effective_Date])) AS [Termination Notice], DateAdd("d",-[Termination_Notice_Req],DateAdd("m",[Contracts]![Initial_term_months],[Contracts]![Effective_Date])) AS [Renewal Notice]
FROM Dept_info INNER JOIN Contracts ON Dept_info.Description_Acct = Contracts.Dept_Desc_Acct
WHERE (((Contracts.Contract_Status)=[Forms]![Search]![CboStatus] or [Forms]![Search]![CboStatus] is null)
 AND ((Contracts.Primary_Vendor_Name)=[Forms]![Search]![CboVend] or [Forms]![Search]![CboVend] is null) 
AND ((Dept_info.COE)=[Forms]![Search]![CboCOE] or [Forms]![Search]![CboCOE]  is null)
 AND ((Contracts.Dept_Desc_Acct)=[Forms]![Search]![CboDepDesc] or [Forms]![Search]![CboDepDesc] is null )
 AND (DateAdd("d",-[Termination_Notice_Req],DateAdd("m",[Contracts]![Initial_term_months],[Contracts]![Effective_Date]))=[Forms]![Search]![txtTermDate] or [Forms]![Search]![txtTermDate] is null )) 
and (((Contracts.Contract_Type) Like "*" & [Forms]![Search]![txtKeyword] & "*") 
or ((Contracts.Description) Like "*" & [Forms]![Search]![txtKeyword] & "*") 
or ((Contracts.Effective_Date) Like "*" & [Forms]![Search]![txtKeyword] & "*"));

Here is what happens if you make a change and save in Design view.

Oops it was to big to post, had to remove a couple of thousand characters

Brian

WHERE (((Contracts.Contract_Status)=[Forms]![Search]![CboStatus]) AND ((Contracts.Primary_Vendor_Name)=[Forms]![Search]![CboVend]) AND ((Contracts.Contract_Type) Like "*" & [Forms]![Search]![txtKeyword] & "*") AND ((Dept_info.COE)=[Forms]![Search]![CboCOE]) AND ((Contracts.Dept_Desc_Acct)=[Forms]![Search]![CboDepDesc]) AND ((DateAdd("d",-[Termination_Notice_Req],DateAdd("m",[Contracts]![Initial_term_months],[Contracts]![Effective_Date])))=[Forms]![Search]![txtTermDate])) OR (((Contracts.Primary_Vendor_Name)=[Forms]![Search]![CboVend]) AND ((Contracts.Contract_Type) Like "*" & [Forms]![Search]![txtKeyword] & "*") AND ((Dept_info.COE)=[Forms]![Search]![CboCOE]) AND ((Contracts.Dept_Desc_Acct)=[Forms]![Search]![CboDepDesc]) AND ((DateAdd("d",-[Termination_Notice_Req],DateAdd("m",[Contracts]![Initial_term_months],[Contracts]![Effective_Date])))=[Forms]![Search]![txtTermDate]) AND (([Forms]![Search]![CboStatus]) Is Null)) OR (((Contracts.Contract_Status)=[Forms]![Search]![CboStatus]) AND ((Contracts.Contract_Type) Like "*" & [Forms]![Search]![txtKeyword] & "*") AND ((Dept_info.COE)=[Forms]![Search]![CboCOE]) AND ((Contracts.Dept_Desc_Acct)=[Forms]![Search]![CboDepDesc]) AND ((DateAdd("d",-[Termination_Notice_Req],DateAdd("m",[Contracts]![Initial_term_months],[Contracts]![Effective_Date])))=[Forms]![Search]![txtTermDate]) AND (([Forms]![Search]![CboVend]) Is Null)) OR (((Contracts.Contract_Type) Like "*" & [Forms]![Search]![txtKeyword] & "*") AND ((Dept_info.COE)=[Forms]![Search]![CboCOE]) AND ((Contracts.Dept_Desc_Acct)=[Forms]![Search]![CboDepDesc]) AND ((DateAdd("d",-[Termination_Notice_Req],DateAdd("m",[Contracts]![Initial_term_months],[Contracts]![Effective_Date])))=[Forms]![Search]![txtTermDate]) AND (([Forms]![Search]![CboStatus]) Is Null) AND (([Forms]![Search]![CboVend]) Is Null)) OR (((Contracts.Contract_Status)=[Forms]![Search]![CboStatus]) AND ((Contracts.Primary_Vendor_Name)=[Forms]![Search]![CboVend]) AND ((Contracts.Contract_Type) Like "*" & [Forms]![Search]![txtKeyword] & "*") AND ((Contracts.Dept_Desc_Acct)=[Forms]![Search]![CboDepDesc]) AND ((DateAdd("d",-[Termination_Notice_Req],DateAdd("m",[Contracts]![Initial_term_months],[Contracts]![Effective_Date])))=[Forms]![Search]![txtTermDate]) AND (([Forms]![Search]![CboCOE]) Is Null)) OR (((Contracts.Primary_Vendor_Name)=[Forms]![Search]![CboVend]) AND ((Contracts.Contract_Type) Like "*" & [Forms]![Search]![txtKeyword] & "*") AND ((Contracts.Dept_Desc_Acct)=[Forms]![Search]![CboDepDesc]) AND ((DateAdd("d",-[Termination_Notice_Req],DateAdd("m",[Contracts]![Initial_term_months],[Contracts]![Effective_Date])))=[Forms]![Search]![txtTermDate]) AND (([Forms]![Search]![CboStatus]) Is Null) AND (([Forms]![Search]![CboCOE]) Is Null)) OR (((Contracts.Contract_Status)=[Forms]![Search]![CboStatus]) AND ((Contracts.Contract_Type) Like "*" & [Forms]![Search]![txtKeyword] & "*") AND ((Contracts.Dept_Desc_Acct)=[Forms]![Search]![CboDepDesc]) AND ((DateAdd("d",-[Termination_Notice_Req],DateAdd("m",[Contracts]![Initial_term_months],[Contracts]![Effective_Date])))=[Forms]![Search]![txtTermDate]) AND (([Forms]![Search]![CboVend]) Is Null) AND (([Forms]![Search]![CboCOE]) Is Null)) OR (((Contracts.Contract_Type) Like "*" & [Forms]![Search]![txtKeyword] & "*") AND ((Contracts.Dept_Desc_Acct)=[Forms]![Search]![CboDepDesc]) AND ((DateAdd("d",-[Termination_Notice_Req],DateAdd("m",[Contracts]![Initial_term_months],[Contracts]![Effective_Date])))=[Forms]![Search]![txtTermDate]) AND (([Forms]![Search]![CboStatus]) Is Null) AND (([Forms]![Search]![CboVend]) Is Null) AND (([Forms]![Search]![CboCOE]) Is Null)) OR (((Contracts.Contract_Status)=[Forms]![Search]![CboStatus]) AND ((Contracts.Primary_Vendor_Name)=[Forms]![Search]![CboVend]) AND ((Contracts.Contract_Type) Like "*" & [Forms]![Search]![txtKeyword] & "*") AND ((Dept_info.COE)=[Forms]![Search]![CboCOE]) AND ((DateAdd("d",-[Termination_Notice_Req],DateAdd("m",[Contracts]![Initial_term_months],[Contracts]![Effective_Date])))=[Forms]![Search]![txtTermDate]) AND (([Forms]![Search]![CboDepDesc]) Is Null)) OR (((Contracts.Primary_Vendor_Name)=[Forms]![Search]![CboVend]) AND ((Contracts.Contract_Type) Like "*" & [Forms]![Search]![txtKeyword] & "*") AND ((Dept_info.COE)=[Forms]![Search]![CboCOE]) AND ((DateAdd("d",-[Termination_Notice_Req],DateAdd("m",[Contracts]![Initial_term_months],[Contracts]![Effective_Date])))=[Forms]![Search]![txtTermDate]) AND (([Forms]![Search]![CboStatus]) Is Null) AND (([Forms]![Search]![CboDepDesc]) Is Null)) OR (((Contracts.Contract_Status)=[Forms]![Search]![CboStatus]) AND ((Contracts.Contract_Type) Like "*" & [Forms]![Search]![txtKeyword] & "*") AND ((Dept_info.COE)=[Forms]![Search]![CboCOE]) AND ((DateAdd("d",-[Termination_Notice_Req],DateAdd("m",[Contracts]![Initial_term_months],[Contracts]![Effective_Date])))=[Forms]![Search]![txtTermDate]) AND (([Forms]![Search]![CboVend]) Is Null) AND (([Forms]![Search]![CboDepDesc]) Is Null)) OR (((Contracts.Contract_Type) Like "*" & [Forms]![Search]![txtKeyword] & "*") AND ((Dept_info.COE)=[Forms]![Search]![CboCOE]) AND ((DateAdd("d",-[Termination_Notice_Req],DateAdd("m",[Contracts]![Initial_term_months],[Contracts]![Effective_Date])))=[Forms]![Search]![txtTermDate]) AND (([Forms]![Search]![CboStatus]) Is Null) AND (([Forms]![Search]![CboVend]) Is Null) AND (([Forms]![Search]![CboDepDesc]) Is Null)) OR (((Contracts.Contract_Status)=[Forms]![Search]![CboStatus]) AND ((Contracts.Primary_Vendor_Name)=[Forms]![Search]![CboVend]) AND ((Contracts.Contract_Type) Like "*" & [Forms]![Search]![txtKeyword] & "*") AND ((DateAdd("d",-[Termination_Notice_Req],DateAdd("m",[Contracts]![Initial_term_months],[Contracts]![Effective_Date])))=[Forms]![Search]![txtTermDate]) AND (([Forms]![Search]![CboCOE]) Is Null) AND (([Forms]![Search]![CboDepDesc]) Is Null)) OR (((Contracts.Primary_Vendor_Name)=[Forms]![Search]![CboVend]) AND ((Contracts.Contract_Type) Like "*" & [Forms]![Search]![txtKeyword] & "*") AND ((DateAdd("d",-[Termination_Notice_Req],DateAdd("m",[Contracts]![Initial_term_months],[Contracts]![Effective_Date])))=[Forms]![Search]![txtTermDate]) AND (([Forms]![Search]![CboStatus]) Is Null) AND (([Forms]![Search]![CboCOE]) Is Null) AND (([Forms]![Search]![CboDepDesc]) Is Null)) OR (((Contracts.Contract_Status)=[Forms]![Search]![CboStatus]) AND ((Contracts.Contract_Type) Like "*" & [Forms]![Search]![txtKeyword] & "*") AND ((DateAdd("d",-[Termination_Notice_Req],DateAdd("m",[Contracts]![Initial_term_months],[Contracts]![Effective_Date])))=[Forms]![Search]![txtTermDate]) AND (([Forms]![Search]![CboVend]) Is Null) AND (([Forms]![Search]![CboCOE]) Is Null) AND (([Forms]![Search]![CboDepDesc]) Is Null)) OR (((Contracts.Contract_Type) Like "*" & [Forms]![Search]![txtKeyword] & "*") AND ((DateAdd("d",-[Termination_Notice_Req],DateAdd("m",[Contracts]![Initial_term_months],[Contracts]![Effective_Date])))=[Forms]![Search]![txtTermDate]) AND (([Forms]![Search]![CboStatus]) Is Null) AND (([Forms]![Search]![CboVend]) Is Null) AND (([Forms]![Search]![CboCOE]) Is Null) AND (([Forms]![Search]![CboDepDesc]) Is Null)) OR (((Contracts.Contract_Status)=[Forms]![Search]![CboStatus]) AND ((Contracts.Primary_Vendor_Name)=[Forms]![Search]![CboVend]) AND ((Contracts.Contract_Type) Like "*" & [Forms]![Search]![txtKeyword] & "*") AND ((Dept_info.COE)=[Forms]![Search]![CboCOE]) AND ((Contracts.Dept_Desc_Acct)=[Forms]![Search]![CboDepDesc]) AND (([Forms]![Search]![txtTermDate]) Is Null)) OR (((Contracts.Primary_Vendor_Name)=[Forms]![Search]![CboVend]) AND ((Contracts.Contract_Type) Like "*" & [Forms]![Search]![txtKeyword] & "*") AND ((Dept_info.COE)=[Forms]![Search]![CboCOE]) AND ((Contracts.Dept_Desc_Acct)=[Forms]![Search]![CboDepDesc]) AND (([Forms]![Search]![CboStatus]) Is Null) AND (([Forms]![Search]![txtTermDate]) Is Null)) OR (((Contracts.Contract_Status)=[Forms]![Search]![CboStatus]) AND ((Contracts.Contract_Type) Like "*" & [Forms]![Search]![txtKeyword] & "*") AND ((Dept_info.COE)=[Forms]![Search]![CboCOE]) AND ((Contracts.Dept_Desc_Acct)=[Forms]![Search]![CboDepDesc]) AND (([Forms]![Search]![CboVend]) Is Null) AND (([Forms]![Search]![txtTermDate]) Is Null)) OR (((Contracts.Contract_Type) Like "*" & [Forms]![Search]![txtKeyword] & "*") AND ((Dept_info.COE)=[Forms]![Search]![CboCOE]) AND ((Contracts.Dept_Desc_Acct)=[Forms]![Search]![CboDepDesc]) AND (([Forms]![Search]![CboStatus]) Is Null) AND (([Forms]![Search]![CboVend]) Is Null) AND (([Forms]![Search]![txtTermDate]) Is Null)) OR (((Contracts.Contract_Status)=[Forms]![Search]![CboStatus]) AND ((Contracts.Primary_Vendor_Name)=[Forms]![Search]![CboVend]) AND ((Contracts.Contract_Type) Like "*" & [Forms]![Search]![txtKeyword] & "*") AND ((Contracts.Dept_Desc_Acct)=[Forms]![Search]![CboDepDesc]) AND (([Forms]![Search]![CboCOE]) Is Null) AND (([Forms]![Search]![txtTermDate]) Is Null)) OR (((Contracts.Primary_Vendor_Name)=[Forms]![Search]![CboVend]) AND ((Contracts.Contract_Type) Like "*" & [Forms]![Search]![txtKeyword] & "*") AND ((Contracts.Dept_Desc_Acct)=[Forms]![Search]![CboDepDesc]) AND (([Forms]![Search]![CboStatus]) Is Null) AND (([Forms]![Search]![CboCOE]) Is Null) AND (([Forms]![Search]![txtTermDate]) Is Null)) OR (((Contracts.Contract_Status)=[Forms]![Search]![CboStatus]) AND ((Contracts.Contract_Type) Like "*" & [Forms]![Search]![txtKeyword] & "*") AND ((Contracts.Dept_Desc_Acct)=[Forms]![Search]![CboDepDesc]) AND (([Forms]![Search]![CboVend]) Is Null) AND (([Forms]![Search]![CboCOE]) Is Null) AND (([Forms]![Search]![txtTermDate]) Is Null)) OR (((Contracts.Contract_Type) Like "*" & [Forms]![Search]![txtKeyword] & "*") AND ((Contracts.Dept_Desc_Acct)=[Forms]![Search]![CboDepDesc]) AND (([Forms]![Search]![CboStatus]) Is Null) AND (([Forms]![Search]![CboVend]) Is Null) AND (([Forms]![Search]![CboCOE]) Is Null) AND (([Forms]![Search]![txtTermDate]) Is Null)) OR (((Contracts.Contract_Status)=[Forms]![Search]![CboStatus]) AND ((Contracts.Primary_Vendor_Name)=[Forms]![Search]![CboVend]) AND ((Contracts.Contract_Type) Like "*" & [Forms]![Search]![txtKeyword] & "*") AND ((Dept_info.COE)=[Forms]![Search]![CboCOE]) AND (([Forms]![Search]![CboDepDesc]) Is Null) AND (([Forms]![Search]![txtTermDate]) Is Null)) OR (((Contracts.Primary_Vendor_Name)=[Forms]![Search]![CboVend]) AND ((Contracts.Contract_Type) Like "*" & [Forms]![Search]![txtKeyword] & "*") AND ((Dept_info.COE)=[Forms]![Search]![CboCOE]) AND (([Forms]![Search]![CboStatus]) Is Null) AND (([Forms]![Search]![CboDepDesc]) Is Null) AND (([Forms]![Search]![txtTermDate]) Is Null)) OR (((Contracts.Contract_Status)=[Forms]![Search]![CboStatus]) AND ((Contracts.Contract_Type) Like "*" & [Forms]![Search]![txtKeyword] & "*") AND ((Dept_info.COE)=[Forms]![Search]![CboCOE]) AND (([Forms]![Search]![CboVend]) Is Null) AND (([Forms]![Search]![CboDepDesc]) Is Null) AND (([Forms]![Search]![txtTermDate]) Is Null)) OR (((Contracts.Contract_Type) Like "*" & [Forms]![Search]![txtKeyword] & "*") AND ((Dept_info.COE)=[Forms]![Search]![CboCOE]) AND (([Forms]![Search]![CboStatus]) Is Null) AND (([Forms]![Search]![CboVend]) Is Null) AND (([Forms]![Search]![CboDepDesc]) Is Null) AND (([Forms]![Search]![txtTermDate]) Is Null)) OR (((Contracts.Contract_Status)=[Forms]![Search]![CboStatus]) AND ((Contracts.Primary_Vendor_Name)=[Forms]![Search]![CboVend]) AND ((Contracts.Contract_Type) Like "*" & [Forms]![Search]![txtKeyword] & "*") AND (([Forms]![Search]![CboCOE]) Is Null) AND (([Forms]![Search]![CboDepDesc]) Is Null) AND (([Forms]![Search]![txtTermDate]) Is Null)) OR (((Contracts.Primary_Vendor_Name)=[Forms]![Search]![CboVend]) AND ((Contracts.Contract_Type) Like "*" & [Forms]![Search]![txtKeyword] & "*") AND (([Forms]![Search]![CboStatus]) Is Null) AND (([Forms]![Search]![CboCOE]) Is Null) AND (([Forms]![Search]![CboDepDesc]) Is Null) AND (([Forms]![Search]![txtTermDate]) Is Null)) OR (((Contracts.Contract_Status)=[Forms]![Search]![CboStatus]) AND ((Contracts.Contract_Type) Like "*" & [Forms]![Search]![txtKeyword] & "*") AND (([Forms]![Search]![CboVend]) Is Null) AND (([Forms]![Search]![CboCOE]) Is Null) AND (([Forms]![Search]![CboDepDesc]) Is Null) AND (([Forms]![Search]![txtTermDate]) Is Null)) OR (((Contracts.Contract_Type) Like "*" & [Forms]![Search]![txtKeyword] & "*") AND (([Forms]![Search]![CboStatus]) Is Null) AND (([Forms]![Search]![CboVend]) Is Null) AND (([Forms]![Search]![CboCOE]) Is Null) AND (([Forms]![Search]![CboDepDesc]) Is Null) AND (([Forms]![Search]![txtTermDate]) Is Null)) OR (((Contracts.Contract_Status)=[Forms]![Search]![CboStatus]) AND ((Contracts.Primary_Vendor_Name)=[Forms]![Search]![CboVend]) AND ((Contracts.Description) Like "*" & [Forms]![Search]![txtKeyword] & "*") AND ((Dept_info.COE)=[Forms]![Search]![CboCOE]) AND ((Contracts.Dept_Desc_Acct)=[Forms]![Search]![CboDepDesc]) AND ((DateAdd("d",-[Termination_Notice_Req],DateAdd("m",[Contracts]![Initial_term_months],[Contracts]![Effective_Date])))=[Forms]![Search]![txtTermDate])) OR (((Contracts.Primary_Vendor_Name)=[Forms]![Search]![CboVend]) AND ((Contracts.Description) Like "*" & [Forms]![Search]![txtKeyword] & "*") AND ((Dept_info.COE)=[Forms]![Search]![CboCOE]) AND ((Contracts.Dept_Desc_Acct)=[Forms]![Search]![CboDepDesc]) AND ((DateAdd("d",-[Termination_Notice_Req],DateAdd("m",[Contracts]![Initial_term_months],[Contracts]![Effective_Date])))=[Forms]![Search]![txtTermDate]) AND (([Forms]![Search]![CboStatus]) Is Null)) OR (((Contracts.Contract_Status)=[Forms]![Search]![CboStatus]) AND ((Contracts.Description) Like "*" & [Forms]![Search]![txtKeyword] & "*") AND ((Dept_info.COE)=[Forms]![Search]![CboCOE]) AND ((Contracts.Dept_Desc_Acct)=[Forms]![Search]![CboDepDesc]) AND ((DateAdd("d",-[Termination_Notice_Req],DateAdd("m",[Contracts]![Initial_term_months],[Contracts]![Effective_Date])))=[Forms]![Search]![txtTermDate]) AND (([Forms]![Search]![CboVend]) Is Null)) OR (((Contracts.Description) Like "*" & [Forms]![Search]![txtKeyword] & "*") AND ((Dept_info.COE)=[Forms]![Search]![CboCOE]) AND ((Contracts.Dept_Desc_Acct)=[Forms]![Search]![CboDepDesc]) AND ((DateAdd("d",-[Termination_Notice_Req],DateAdd("m",[Contracts]![Initial_term_months],[Contracts]![Effective_Date])))=[Forms]![Search]![txtTermDate]) AND (([Forms]![Search]![CboStatus]) Is Null) AND (([Forms]![Search]![CboVend]) Is Null)) OR (((Contracts.Contract_Status)=[Forms]![Search]![CboStatus]) AND ((Contracts.Primary_Vendor_Name)=[Forms]![Search]![CboVend]) AND ((Contracts.Description) Like "*" & [Forms]![Search]![txtKeyword] & "*") AND ((Contracts.Dept_Desc_Acct)=[Forms]![Search]![CboDepDesc]) AND ((DateAdd("d",-[Termination_Notice_Req],DateAdd("m",[Contracts]![Initial_term_months],[Contracts]![Effective_Date])))=[Forms]![Search]![txtTermDate]) AND (([Forms]![Search]![CboCOE]) Is Null)) OR (((Contracts.Primary_Vendor_Name)=[Forms]![Search]![CboVend]) AND ((Contracts.Description) Like "*" & [Forms]![Search]![txtKeyword] & "*") AND ((Contracts.Dept_Desc_Acct)=[Forms]![Search]![CboDepDesc]) AND ((DateAdd("d",-[Termination_Notice_Req],DateAdd("m",[Contracts]![Initial_term_months],[Contracts]![Effective_Date])))=[Forms]![Search]![txtTermDate]) AND (([Forms]![Search]![CboStatus]) Is Null) AND (([Forms]![Search]![CboCOE]) Is Null)) OR (((Contracts.Contract_Status)=[Forms]![Search]![CboStatus]) AND ((Contracts.Description) Like "*" & [Forms]![Search]![txtKeyword] & "*") AND ((Contracts.Dept_Desc_Acct)=[Forms]![Search]![CboDepDesc]) AND ((DateAdd("d",-[Termination_Notice_Req],DateAdd("m",[Contracts]![Initial_term_months],[Contracts]![Effective_Date])))=[Forms]![Search]![txtTermDate]) AND (([Forms]![Search]![CboVend]) Is Null) AND (([Forms]![Search]![CboCOE]) Is Null)) OR (((Contracts.Description) Like "*" & [Forms]![Search]![txtKeyword] & "*") AND ((Contracts.Dept_Desc_Acct)=[Forms]![Search]![CboDepDesc]) AND ((DateAdd("d",-[Termination_Notice_Req],DateAdd("m",[Contracts]![Initial_term_months],[Contracts]![Effective_Date])))=[Forms]![Search]![txtTermDate]) AND (([Forms]![Search]![CboStatus]) Is Null) AND (([Forms]![Search]![CboVend]) Is Null) AND (([Forms]![Search]![CboCOE]) Is Null)) OR (((Contracts.Contract_Status)=[Forms]![Search]![CboStatus]) AND ((Contracts.Primary_Vendor_Name)=[Forms]![Search]![CboVend]) AND ((Contracts.Description) Like "*" & [Forms]![Search]![txtKeyword] & "*") AND ((Dept_info.COE)=[Forms]![Search]![CboCOE]) AND ((DateAdd("d",-[Termination_Notice_Req],DateAdd("m",[Contracts]![Initial_term_months],[Contracts]![Effective_Date])))=[Forms]![Search]![txtTermDate]) AND (([Forms]![Search]![CboDepDesc]) Is Null)) OR (((Contracts.Primary_Vendor_Name)=[Forms]![Search]![CboVend]) AND ((Contracts.Description) Like "*" & [Forms]![Search]![txtKeyword] & "*") AND ((Dept_info.COE)=[Forms]![Search]![CboCOE]) AND ((DateAdd("d",-[Termination_Notice_Req],DateAdd("m",[Contracts]![Initial_term_months],[Contracts]![Effective_Date])))=[Forms]![Search]![txtTermDate]) AND (([Forms]![Search]![CboStatus]) Is Null) AND (([Forms]![Search]![CboDepDesc]) Is Null)) OR (((Contracts.Contract_Status)=[Forms]![Search]![CboStatus]) AND ((Contracts.Description) Like "*" & [Forms]![Search]![txtKeyword] & "*") AND ((Dept_info.COE)=[Forms]![Search]![CboCOE]) AND ((DateAdd("d",-[Termination_Notice_Req],DateAdd("m",[Contracts]![Initial_term_months],[Contracts]![Effective_Date])))=[Forms]![Search]![txtTermDate]) AND (([Forms]![Search]![CboVend]) Is Null) AND (([Forms]![Search]![CboDepDesc]) Is Null)) OR (((Contracts.Description) Like "*" & [Forms]![Search]![txtKeyword] & "*") AND ((Dept_info.COE)=[Forms]![Search]![CboCOE]) AND ((DateAdd("d",-[Termination_Notice_Req],DateAdd("m",[Contracts]![Initial_term_months],[Contracts]![Effective_Date])))=[Forms]![Search]![txtTermDate]) AND (([Forms]![Search]![CboStatus]) Is Null) AND (([Forms]![Search]![CboVend]) Is Null) AND (([Forms]![Search]![CboDepDesc]) Is Null)) OR (((Contracts.Contract_Status)=[Forms]![Search]![CboStatus]) AND ((Contracts.Primary_Vendor_Name)=[Forms]![Search]![CboVend]) AND ((Contracts.Description) Like "*" & [Forms]![Search]![txtKeyword] & "*") AND ((DateAdd("d",-[Termination_Notice_Req],DateAdd("m",[Contracts]![Initial_term_months],[Contracts]![Effective_Date])))=[Forms]![Search]![txtTermDate]) AND (([Forms]![Search]![CboCOE]) Is Null) AND (([Forms]![Search]![CboDepDesc]) Is Null)) OR (((Contracts.Primary_Vendor_Name)=[Forms]![Search]![CboVend]) AND ((Contracts.Description) Like "*" & [Forms]![Search]![txtKeyword] & "*") AND ((DateAdd("d",-[Termination_Notice_Req],DateAdd("m",[Contracts]![Initial_term_months],[Contracts]![Effective_Date])))=[Forms]![Search]![txtTermDate]) AND (([Forms]![Search]![CboStatus]) Is Null) AND (([Forms]![Search]![CboCOE]) Is Null) AND (([Forms]![Search]![CboDepDesc]) Is Null)) OR (((Contracts.Contract_Status)=[Forms]![Search]![CboStatus]) AND ((Contracts.Description) Like "*" & [Forms]![Search]![txtKeyword] & "*") AND ((DateAdd("d",-[Termination_Notice_Req],DateAdd("m",[Contracts]![Initial_term_months],[Contracts]![Effective_Date])))=[Forms]![Search]![txtTermDate]) AND (([Forms]![Search]![CboVend]) Is Null) AND (([Forms]![Search]![CboCOE]) Is Null) AND (([Forms]![Search]![CboDepDesc]) Is Null)) OR (((Contracts.Description) Like "*" & [Forms]![Search]![txtKeyword] & "*") AND ((DateAdd("d",-[Termination_Notice_Req],DateAdd("m",[Contracts]![Initial_term_months],[Contracts]![Effective_Date])))=[Forms]![Search]![txtTermDate]) AND (([Forms]![Search]![CboStatus]) Is Null) AND (([Forms]![Search]![CboVend]) Is Null) AND (([Forms]![Search]![CboCOE]) Is Null) AND (([Forms]![Search]![CboDepDesc]) Is Null)) OR (((Contracts.Contract_Status)=[Forms]![Search]![CboStatus]) AND ((Contracts.Primary_Vendor_Name)=[Forms]![Search]![CboVend]) AND ((Contracts.Description) Like "*" & [Forms]![Search]![txtKeyword] & "*") AND ((Dept_info.COE)=[Forms]![Search]![CboCOE]) AND ((Contracts.Dept_Desc_Acct)=[Forms]![Search]![CboDepDesc]) AND (([Forms]![Search]![txtTermDate]) Is Null)) OR (((Contracts.Primary_Vendor_Name)=[Forms]![Search]![CboVend]) AND ((Contracts.Description) Like "*" & [Forms]![Search]![txtKeyword] & "*") AND ((Dept_info.COE)=[Forms]![Search]![CboCOE]) AND ((Contracts.Dept_Desc_Acct)=[Forms]![Search]![CboDepDesc]) AND (([Forms]![Search]![CboStatus]) Is Null) AND (([Forms]![Search]![txtTermDate]) Is Null)) OR (((Contracts.Contract_Status)=[Forms]![Search]![CboStatus]) AND ((Contracts.Description) Like "*" & [Forms]![Search]![txtKeyword] & "*") AND ((Dept_info.COE)=[Forms]![Search]![CboCOE]) AND ((Contracts.Dept_Desc_Acct)=[Forms]![Search]![CboDepDesc]) AND (([Forms]![Search]![CboVend]) Is Null) AND (([Forms]![Search]![txtTermDate]) Is Null)) OR (((Contracts.Description) Like "*" & [Forms]![Search]![txtKeyword] & "*") AND ((Dept_info.COE)=[Forms]![Search]![CboCOE]) AND ((Contracts.Dept_Desc_Acct)=[Forms]![Search]![CboDepDesc]) AND (([Forms]![Search]![CboStatus]) Is Null) AND (([Forms]![Search]![CboVend]) Is Null) AND (([Forms]![Search]![txtTermDate]) Is Null)) OR (((Contracts.Contract_Status)=[Forms]![Search]![CboStatus]) AND ((Contracts.Primary_Vendor_Name)=[Forms]![Search]![CboVend]) AND ((Contracts.Description) Like "*" & [Forms]![Search]![txtKeyword] & "*") AND ((Contracts.Dept_Desc_Acct)=[Forms]![Search]![CboDepDesc]) AND (([Forms]![Search]![CboCOE]) Is Null) AND (([Forms]![Search]![txtTermDate]) Is Null)) OR (((Contracts.Primary_Vendor_Name)=[Forms]![Search]![CboVend]) AND ((Contracts.Description) Like "*" & [Forms]![Search]![txtKeyword] & "*") AND ((Contracts.Dept_Desc_Acct)=[Forms]![Search]![CboDepDesc]) AND (([Forms]![Search]![CboStatus]) Is Null) AND (([Forms]![Search]![CboCOE]) Is Null) AND (([Forms]![Search]![txtTermDate]) Is Null)) OR (((Contracts.Contract_Status)=[Forms]![Search]![CboStatus]) AND ((Contracts.Description) Like "*" &