Search results

  1. S

    MS Access - Between Dates queries using variables from forms

    You are heaven sent! Thank you for this. I do have a date (picker) control in my form so I just had to insert CDate and it worked wonders. For the benefit of the others who are having the same problem here it is: User enters ff value in GenForm: StartDate = 07-Apr-10 EndDate = 09-May-10 This...
  2. S

    Time confusion

    Try this: select * from lessons where Format([date_math], "Short Date") = #29-May-2008# AND Format([end_time], "Short Time") > #13:00# AND Format([end_time], "Short Time") <= #14:30#)
  3. S

    MS Access - Between Dates queries using variables from forms

    I have a table with [Call Start] as Date/Time General Date which has data from March 30, 2010 until May 9, 2010. I want to create a query wherein I can get a date range from user given starting and ending date from a Form (GenForm): User enters ff value in GenForm: StartDate = 07-Apr-10...
Back
Top Bottom