Problems with Parameter Queries!

[atiq]

i have a Query where i have Criteria for two fields as the following:

Field :Date of Incident
Crirteria: [Forms]![frmSearchStuden t&Date]![cboStartDate] And [Forms]![frmSearchStuden t&Date]![cboEndDate]

Field: StudentSurname
Criteria: [Forms]![frmSearchStuden t&Date]![Combo0]

Occasionally, staff may just want all incidents (records) to be shown for the selected StudentSurname and so, just select the surname and leave the date fields blank.

i tried the following:
Field :Date of Incident
Crirteria: [Forms]![frmSearchStuden t&Date]![cboStartDate] And [Forms]![frmSearchStuden t&Date]![cboEndDate]
Or: [Forms]![frmSearchStuden t&Date]![cboStartDate] Is Null And [Forms]![frmSearchStuden t&Date]![cboEndDate] Is Null

Field: StudentSurname
Criteria: [Forms]![frmSearchStuden t&Date]![Combo0]

then when i tested this by leaving the date fields blank and selecting a valid student surname it simply returned all incidents (records) for ALL students not the selected one.

is it possible to achieve this? if so, could someone please help!

[MMcCarthy]

Try this ...

Field :Date of Incident
Crirteria: IIf(Not IsNull([Forms]![frmSearchStuden t&Date]![cboStartDate]), [Forms]![frmSearchStuden t&Date]![cboStartDate] And [Forms]![frmSearchStuden t&Date]![cboEndDate])

Field: StudentSurname
Criteria: [Forms]![frmSearchStuden t&Date]![Combo0]

Mary

[atiq]

Try this ...

Field :Date of Incident
Crirteria: IIf(Not IsNull([Forms]![frmSearchStuden t&Date]![cboStartDate]), [Forms]![frmSearchStuden t&Date]![cboStartDate] And [Forms]![frmSearchStuden t&Date]![cboEndDate])

Field: StudentSurname
Criteria: [Forms]![frmSearchStuden t&Date]![Combo0]

Mary

I tried using this expression but it doesn't work neither does it display any error messages.

[MMcCarthy]

Try this ...

Field :Date of Incident
Crirteria: IIf(Not IsNull([Forms]![frmSearchStuden t&Date]![cboStartDate]), BETWEEN [Forms]![frmSearchStuden t&Date]![cboStartDate] AND [Forms]![frmSearchStuden t&Date]![cboEndDate])



Mary