Search results

  1. B

    create SQL query to search between two dates in existing query

    I solved it myself. I just used >= and <= for the date query. Works like a charm SELECT Task.TaskID, Task.Date, Task.[Serial #], Severity.Severity, TaskStatus.TaskStatus, Employees.Employees, Task.Comments FROM TaskStatus INNER JOIN (Severity INNER JOIN (Employees INNER JOIN Task ON...
  2. B

    create SQL query to search between two dates in existing query

    well, I got the SQL statement to take, without causing an error, but unfortunatly it returns incorrect results This is the SQL code now : SELECT Task.TaskID, Task.Date, Task.[Serial #], Severity.Severity, TaskStatus.TaskStatus, Employees.Employees, Task.Comments FROM TaskStatus INNER JOIN...
  3. B

    create SQL query to search between two dates in existing query

    Hello I am creating a database for work that allows me to enter maintenance tasks for computers into an access database using forms. I have one main table that holds all of the data re the tasks. Its called "Tasks" and comtains the following fields: TaskID (primary key) EmployeeID Date...
Back
Top Bottom