Search results

Ok i have figured out that the remote server i am querying has the date stored as smalldatetime. What format do i need to make the textbox on the form where the user inputs the date they want to search, so i can get it to return all records for that date (don't care about the time).

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...

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)...