return all values when criteria is null in a Between expression

[Benwatson]

hi all i have a query that criteria is linked to a form now i need the query to return all the results even if the criteria box is null this includes two date fields

so this is the code i have but keeps throwing it back saying its too complicated or entered incorrectly

Between IIf(IsNull([Forms]![frmfeedbackgiven]![txtdatefrom]),"*",[Forms]![frmfeedbackgiven]![txtdatefrom]) And IIf(IsNull([Forms]![frmfeedbackgiven]![txtdateto]),"*",[Forms]![frmfeedbackgiven]![txtdateto])

please help

 

[Minty]

have a look here https://access-programmers.co.uk/forums/showthread.php?t=59853 your question is almost identical !