Search results

  1. A

    Query partial match

    Hi, I have the below where clause to return data from a date range. WHERE ((LEFT(tbl_Triage.TIMESTAMP, 10) >=[Forms]![frm_SearchTransactions]![txtDateFrom]) OR ([Forms]![frm_SearchTransactions]![txtDateFrom] Is Null)) AND ((LEFT(tbl_Triage.TIMESTAMP, 10)...
  2. A

    Open ended criteria

    Hi All, I'm new to access and feeling my way in the dark a little. I'm building a form for users to enter parameter criteria and it's coming along nicely. The form is such that a user can enter data for some or all parameters or any combination of them. All good. Here comes the but... In...
Back
Top Bottom