Search results

  1. M

    data type mismatch on date field from form in my sql query

    I am having a hard time getting my sql query to accept a date value in the WHERE clause. The date is being input by the user on a form (textbox formatted as short date) The date which is being refrenced to in the query resides on another table on a server. I linked the table in my access...
  2. M

    need help identifying table value as a variable in an sql command

    I have no real experience programming, i have been teaching myself things as i go along. Here is my issue. I am trying to create a from where you can enter an id and a date range and hit the button on the form to activate code that does the following: query1: creates a new table (table_data)...
Back
Top Bottom