Search results

  1. O

    Converting a SQL Statement to a Dlookup

    Hey Guys Dale - Not to worry... im a little short on coffee this morning as well :) Paul - That fixed it, the delimiters for date were added, and the system is displayinig the data correctly now. Thanks for the assist! Chris
  2. O

    Converting a SQL Statement to a Dlookup

    Hey Dale Just trying to clarify here. My SQL Statement works fine, but the DLookup is not. I am trying to have the dlookup provide the same result as the SQL i posted, so that when the form loads, the control wf1oi has the default value set by it. Currently, the dlookup is providing a Null...
  3. O

    Converting a SQL Statement to a Dlookup

    Hey Dale All the control values are numeric - i_olddate is a date value - wfid1 and wfc1 are numeric The result to be placed into wf1oi would be numeric as well Hope this helps explain it better
  4. O

    Converting a SQL Statement to a Dlookup

    Hello all I have the following SQL Statement which returns the desired result to me SELECT tbl_p_stats.i_closing FROM tbl_p_stats WHERE (((tbl_p_stats.i_weekending)=[forms]![frm_a]![i_olddate]) AND ((tbl_p_stats.i_sacat)=[forms]![frm_a]![wfid1]) AND...
Back
Top Bottom