iif function for searching in record and view in report page

[john aso]

i have a code i need it but i think its bad i ned to joien specific record to a report page for searching data
this code i right it in query criteria under the field i want to see in the report page

(IIf(IsNull([froms].[frmempSearch].[datefrom]),"MaxOfExpireDate",([qryLastResidancy].[MaxOfExpireDate])=[froms].[frmempSearch].[datefrom] And ([qryLastResidancy].[MaxOfExpireDate])=[froms].[frmempSearch].[dateto]))

thanks.

[jimatqsi]

You have [froms] several times. It should be [Forms].

Jim