VB Code:
invdate <= #" & cboTdate & " # and invdate >= #" & cboFdate & " #
both cboTdate and cbdFdate are combo boxes that contain date values..
the thing is, when cboTdate is 1-Apr-2002 and cboFdate is 20-Apr-2002, the output is correct ..
but if cboFdate is 30-Mar-2002 and cboTdate is 20-Apr-2002, nothing comes out.. is my code wrong?![]()




Reply With Quote