G
Guest
As the subject says, I am trying to get a query to return anything prior to a
date that is input or if no date is input, I would like it to return those
dates that are prior to now(). I have this working for a combo box on the
form with the following
Like IIf(nz([forms]![PAST_DUE]![cboINSPECTIONTYPE],"")<>"","*" &
[forms]![PAST_DUE]![cboINSPECTIONTYPE] & "*","*")
but I am having trouble getting something to work for a date text box. The
date text box is on the same form [PAST_DUE] and is txtDATE. If someone
could help me out with getting this to work and maybe explain a little more
to me about what I used above as I got help to put it together and I
obviously don't understand it Thanks.
date that is input or if no date is input, I would like it to return those
dates that are prior to now(). I have this working for a combo box on the
form with the following
Like IIf(nz([forms]![PAST_DUE]![cboINSPECTIONTYPE],"")<>"","*" &
[forms]![PAST_DUE]![cboINSPECTIONTYPE] & "*","*")
but I am having trouble getting something to work for a date text box. The
date text box is on the same form [PAST_DUE] and is txtDATE. If someone
could help me out with getting this to work and maybe explain a little more
to me about what I used above as I got help to put it together and I
obviously don't understand it Thanks.