Recent content by barwood

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

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

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