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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top