Compare Logged Project Time to Expected Project Time

[Mike]

Hi Everyone, I'm hoping someone can help me with this, I am not getting all
the data I want displayed. I would like it to also include all the other
projects with the select resources under JxTT_Hours and not just the ones
that match both Projects. I hope that makes sense. Please let me know if
need to give more of an idea of what I am trying to do.
Thank you in advance for any help you can offer.

SELECT JxTT_Hours.Jx_User, JxTT_Hours.Jx_Wc, Expected_Hours.Exp_Wc,
JxTT_Hours.Jx_Hours, Expected_Hours.Exp_Hours
FROM Expected_Hours LEFT JOIN JxTT_Hours ON Expected_Hours.Exp_Resource =
JxTT_Hours.Jx_User
WHERE (((JxTT_Hours.Jx_Hours)=IIf([Jx_Wc]=[Exp_Wc],[Jx_Hours],0)))
ORDER BY JxTT_Hours.Jx_User;

 

[KARL DEWEY]

WHERE (((JxTT_Hours.Jx_Hours)=IIf([Jx_Wc]=[Exp_Wc],[Jx_Hours],0)))
Here you are only to display records when the work center of both tables
match. The hours to equal means nothing as it is comparing the same hours.

Try this --
WHERE ([Jx_Wc]=[Exp_Wc]) Or (JxTT_Hours.Jx_Hours Is Null) Or
(JxTT_Hours.Jx_Hours = 0)