• It depends if you're looking for an additional criteria:

    WHERE CABWO_CABLE_WORK_ORDERS.WO_NO=[Please Enter WO Number] AND CABWO_CABLE_WORK_ORDERS.ISS_NO)=[Please Enter Issue Number] AND CABWO_WO_DETAILS.TITLE)=[Please Enter Title];

    or an alternative criteria:

    WHERE ((CABWO_CABLE_WORK_ORDERS.WO_NO=[Please Enter WO Number] AND CABWO_CABLE_WORK_ORDERS.ISS_NO=[Please Enter Issue Number]) OR (CABWO_WO_DETAILS.TITLE=[Please Enter Title]));



    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]