Query with three criterias

[mulberry13]

I have a query that I pull a report of new referrals. It works fine but we are finding children who discharged but then were 're opened" with a new start date.
The first criteria is: Start Date which I entered >6/30/2011
The second criteria is: in the "or" line with a "re opened dt" >6/30/2011
both of these run fine but now I need to filter out Armstrong County from Westmoreland County and when I add <> Armstrong County, it still gives me all counties.
Can you tell me what I am doing wrong?

 

[Darren Bartrup]

Could you post the SQL for the query please, will make it easier to debug the problem.

 

[mulberry13]

not sure what you mean (sorry) or how I can put it in this document.

 

[boblarson]

not sure what you mean (sorry) or how I can put it in this document.

Open the query in design view. Then go to VIEW > SQL VIEW and then copy that and then paste it into a new post here.

 

[boblarson]

By the way the criteria should be:

> #6/30/2011#
> #6/30/2011#

<> "Armstrong County"

If the date fields are date datatypes then you need the octothorpes (#) and if they are text you need quotes instead. And for the county you need quotes if it is text, which I assume it is. But that may not be the case if you have a lookup field set in that table (which would be not so good).

 

[mulberry13]

SELECT tblClients.LastName, tblClients.FirstName, tblClients.[Active Status], tblClients.KidsKlubStartDt, tblClients.KidsKlubDischargeDt, tblClients.KidsKlub_Re_Open_DT, tblClients.Initial_Survey_completed, tblClients.Discharge_Survey_Done, tblClients.[County Code]
FROM tblClients
WHERE (((tblClients.KidsKlubStartDt)>#6/30/2011#) AND ((tblClients.[County Code]) Like "West")) OR (((tblClients.KidsKlub_Re_Open_DT)>#6/30/2011#));

 

[boblarson]

I think you need to add the wildcard to your LIKE:

WHERE (((tblClients.KidsKlubStartDt)>#6/30/2011#) AND ((tblClients.[County Code]) Like "West*")) OR (((tblClients.KidsKlub_Re_Open_DT)>#6/30/2011#));

 

[mulberry13]

Thanks didn't even think of that I will give it a try.