Help with a where clause

[Dom606]

I have the following query as the record source for a report. I cannot seem to get the WHERE clause to evaluate the two conditions between the OR statement correctly. I tried several ways to enclose the two conditions with parentheses but must be doing something wrong.

SELECT tblProjects.[Project Name], Employees.[Last Name], Employees.[First Name], tblAssignments.[Assignment Start Date], tblAssignments.[Assignment End Date], tblAssignments.[Assignment Percent Utilized], tblProjects.[Project Category], Employees.Empl_Status
FROM tblProjects INNER JOIN (Employees INNER JOIN tblAssignments ON Employees.[Employee ID] = tblAssignments.[Employee ID]) ON tblProjects.ProjectID = tblAssignments.ProjectID
[COLOR=red]
WHERE (((tblAssignments.[Assignment Percent Utilized])<>0)) OR (((tblAssignments.[Assignment Percent Utilized])=0)) And (((tblAssignments.[ProjectID])=0))[/color]

ORDER BY tblProjects.[Project Name];

 

[lespaul]

so what should the criteria be?

If you have:

WHERE [COLOR=red]([/color]tblAssignments.[Assignment Percent Utilized]<>0[COLOR=red])[/color] OR [COLOR=blue]([/color]tblAssignments.[Assignment Percent Utilized]=0 AND tblAssignments.[ProjectID]=0[COLOR=blue])[/color]

then you will get all records where [Assignment Percent Utilized]<>0 and you will also records where (tblAssignments.[Assignment Percent Utilized]=0 AND tblAssignments.[ProjectID]=0). Is that what you need?

Leslie

Have you met Hardy Heron?

 

[Dom606]

Hi Leslie,
What I need is to select records
if tblAssignments.[Assignment Percent Utilized]<>0
Or
if tblAssignments.[Assignment Percent Utilized]=0 AND tblAssignments.[ProjectID]=0)

 

[lespaul]

ok, did you test the WHERE clause I posted? that's what it should do....

 

[Dom606]

I tried your suggestion. It correctly performs the left side of the OR statement. However, I am not getting records that meet the criteria on right side of the OR statement.

 

[Dom606]

Leslie, you are correct it does work as you suggested. I fat fingered the where statement.

Thank you so much. This was driving me nuts.
Dom

 

[lespaul]

no problem! glad you got it!

 

[PHV]

A simpler way:
WHERE tblAssignments.[Assignment Percent Utilized]<>0 OR tblAssignments.[ProjectID]=0

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Dom606]

Thanks PH. I guess there are many ways to skin that cat.
Unfortunately, I could not figure out any of them!

Thanks again for the help.
Dom