Re: I want to select either specific records or all in same query
- From: Marshall Barton <marshbarton@xxxxxxxxxx>
- Date: Thu, 30 Mar 2006 23:56:42 -0600
mikeycan wrote:
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
SELECT *
FROM thetable
WHERE [team member] = Forms!theform.thecombo
OR Forms!theform.thecombo Is Null
--
Marsh
MVP [MS Access]
.
- Prev by Date: Re: How do I used wildcard characters in Query by Form?
- Next by Date: Re: Problem with memo field in query
- Previous by thread: Re: How do I used wildcard characters in Query by Form?
- Next by thread: RE: Left Join Not Properly
- Index(es):
