Unable to retreive the right value from form

[willy292]

I have very green in access, which I would like to search the project by team and more than team can take over on the same project. If tick the box for teamA and teamB, only project do by both team
can be display, but my Access query as below cannot work, please help

I have a table, form and a query

Table structure

Project Name , Description , teamA(Yes/No Box), teamB (Yes/No Box), teamC (Yes/No Box)

Form namely search project by team
show three Yes /No box for selection

query

SELECT Projects.[Project Name],
Projects.[Project Description], Projects.[Project Category], Projects.[Start


Date], Projects.[Est Completion Date], Projects.[End Date], Projects.[Project
Benefits/ Impact], Projects.[IT Resource], Projects.[Key Participant], Projects.[Last Update/Comments],
Projects.[Action Owners], Projects.Status, Projects.Activity,

FROM Projects

WHERE (((Projects.[TeamA])=[Forms]![Search Project by Team]![TeamA]) AND ((Projects.[TeamB])=[Forms]![Search Project by Team]![TeamB]) AND ((Projects.[TeamC ])=[Forms]![Search Project by Team]![TeamC]))

[Dal Jeanis]

In general, it looks fine. The two things that look wrong to me are this -

1) There should not be a comma after the last field being selected.

2) There should not be a space between the first "[TeamC" and "]" in this part ->

((Projects.[TeamC ])=[Forms]![Search Project by Team]![TeamC]))

If fixing those doesn't fix it, then please describe the exact error message (or behavior) you get.

[willy292]

no error message but no record found

[Dal Jeanis]

OKay, try this

WHERE (
     (((Projects.[TeamA])=[Forms]![Search Project by Team]![TeamA]) OR ((Projects.[TeamA])IS NULL)) 
AND  (((Projects.[TeamB])=[Forms]![Search Project by Team]![TeamB]) OR ((Projects.[TeamB])IS NULL)) 
AND  (((Projects.[TeamC])=[Forms]![Search Project by Team]![TeamC]) OR ((Projects.[TeamC])IS NULL)) 
      )