Where criteria depends on a form's text control

Topic

New Reply

I need to add a where clause to the following statement. The criteria needs to be < the value (date) in forms!frmPaSu!txtDt, if there is one. Needs to return all records if there is no user entered value in the text box.

SELECT tblTest.lngTestID, tblTest.strTestTypeK, tblTest.lngVehID, tblTest.dtmDtTmS AS dtmCurDt, tblTest.strPurposeK
FROM tblTest;

Need some help.

Reply | Quote

Replies

I need to add a where clause to the following statement. The criteria needs to be < the value (date) in forms!frmPaSu!txtDt, if there is one. Needs to return all records if there is no user entered value in the text box.

SELECT tblTest.lngTestID, tblTest.strTestTypeK, tblTest.lngVehID, tblTest.dtmDtTmS AS dtmCurDt, tblTest.strPurposeK
FROM tblTest;

Need some help.

Try this

Where (((tblTest.dtmDtTmS)<[Forms]![frmPaSu]![txtDt])) OR (([Forms]![frmPaSu]![txtDt] Is Null))

Reply | Quote

Try this

Where (((tblTest.dtmDtTmS)<[Forms]![frmPaSu]![txtDt])) OR (([Forms]![frmPaSu]![txtDt] Is Null))

Nailed it. Thanks

Reply | Quote