Search results

  1. A

    SQL Syntax Date format English v American

    I am trying to query a set of records on a date field via code using memory variables as below: dtFrom = Format(dtFrom, "dd/mm/yy") dtTo = Format(dtTo , "dd/mm/yy") ' I have also tried using CDate in both cases the set of records return a selection that is equivalent to the dates being...
  2. A

    Parameter qry Error (3061) Parametr is TextBox on a form

    Hi Just wondered if anyone could shed some light on the issue I am having. I have a saved parameter query that will not run when I point the parameter to a TextBox on a form. The error is 3061 "Too few parameters. Expected 1." It is a number, if I enter the number directly in the sql then...
Back
Top Bottom