IIf IsNull Problems 1

[smdemo]

I have a query that is linked to a search form that I am having issues with. I am fine with everything until I get to including a date range. I used the criteria of 'IIf(IsNull([Forms].[Search].[BeginDate])=True,[SubmitDate],Between [Forms].[Search].[BeginDate] And [Forms].[Search].[EndDate])' for the date field and it doesn't seem to want to work. I'd appreciate any help someone may be able to provide.

Thanks
Steve

 

[dhookom]

You can't place the operator (BETWEEN) inside the IIf(). Try

[SubmitDate] Between [Forms].[Search].[BeginDate] And [Forms].[Search].[EndDate] OR [Forms].[Search].[BeginDate] Is Null

Duane
Hook'D on Access
MS Access MVP

 

[smdemo]

Worked perfect. Thanks a bunch.