I want to select either specific records or all in same query

M

mikeycan

I want to select a either records with a specific "team member" based on a
combo box or all team members if the combo box is left blank
 
M

Marshall Barton

mikeycan said:
I want to select a either records with a specific "team member" based on a
combo box or all team members if the combo box is left blank
Click to expand...


SELECT *
FROM thetable
WHERE [team member] = Forms!theform.thecombo
OR Forms!theform.thecombo Is Null
 
Top