Search results

  1. R

    DLookup with Multiple Criteria

    Actually, I retyped your formula and it works perfectly. The error was on my end. Thank you so much for the help!!
  2. R

    DLookup with Multiple Criteria

    Thanks for the quick response. When I tried the formula it returned a #Error message. Do you know what I am doing wrong? =DLookUp("Date","qryDatePosition","DOWPosition='1S aturday' AND Month=" & Forms![frmCalendar]![cboMonth] & " AND Year=" & Forms![frmCalendar]![cboYear])
  3. R

    DLookup with Multiple Criteria

    Hello all, I am struggling with adding multiple criteria with a DLookup formula. Here is the initial criteria: =DLookUp("Date","qryDatePosition","DOWPosition='1Saturday' ") I am trying to add two additional criteria. "Month" = Forms![frmCalendar]![cboMonth] "Year" =...
  4. R

    CROSS TAB Query #name? error

    Problem solved! Thank you for the help!
  5. R

    CROSS TAB Query #name? error

    Hello everyone, I have a crosstab query within an employee attendance tracker. The query is displaying #name? errors in some of the columns. Is their a way to fix remove the errors and still keep the column? I have attached screenshots ot the Design View and Display View of the query. Any...
Back
Top Bottom