How to include optional field in querydesign mode

[pratim09]

I have search form which is based on a requery on a subform .The subform record source has the query with fours fields. (2 optional 2 mandatory) .How to write in the criteria section for the coumn (in the query design mode) which are optional . Any help is appreciated.

[orange]

Perhaps some sample data would help, but my first thought for the query is

Select mandatoryFld1, MandatoryFld2, Opt1 , Opt2 from MyTable
where
mandatoryFld1 is Not Null and
mandatoryFld2 is Not Null

[pratim09]

I tried the below query but still its not working . I ma not getting any row returned .The name and date is mandatory in the query .Any help on this plz?

SELECT TBL_HOURS_TRACKING.TrackingId, TBL_HOURS_TRACKING.ReleaseName, TBL_HOURS_TRACKING.ProjectName, TBL_HOURS_TRACKING.WorkIdentifier, TBL_HOURS_TRACKING.DefectNo, TBL_HOURS_TRACKING.HDTNo, TBL_HOURS_TRACKING.TestType, TBL_HOURS_TRACKING.Name, TBL_HOURS_TRACKING.ActualMonth, TBL_HOURS_TRACKING.WorkItem, TBL_HOURS_TRACKING.Hours, TBL_HOURS_TRACKING.Comments
FROM TBL_HOURS_TRACKING
WHERE (((TBL_HOURS_TRACKING.ProjectName)=[Forms]![frmHoursTrackingModify]![cmbProjectName]) AND ((TBL_HOURS_TRACKING.WorkIdentifier)=[Forms]![frmHoursTrackingModify]![WorkId]) AND ([Forms]![frmHoursTrackingModify]![Name] Is Not Null) AND ((TBL_HOURS_TRACKING.ActualMonth) Between [Forms]![frmHoursTrackingModify]![txtStartDate] And [Forms]![frmHoursTrackingModify]![txtEndDate] Is Not Null));

[orange]

If you're running this query from a button on a form, I'd recommend you insert some vba
to do some debug.print statements.
Check and see what the values are for
[Forms]![frmHoursTrackingModify]![cmbProjectName]
[Forms]![frmHoursTrackingModify]![WorkId]
[Forms]![frmHoursTrackingModify]![Name]
[Forms]![frmHoursTrackingModify]![txtStartDate]
[Forms]![frmHoursTrackingModify]![txtEndDate]

My guess is that no records meet your criteria.