ive got a table that has 3 different date fields, 1 task status field, 1 employee ID field (there are more fields, but those are the important ones). I'm building a report where i collect the daily activity of an employee. It needs to return any record where the current date resides in either of the 3 date fields, AND that only returns records that belong to the specified employee, AND of those records, only brings back records where the status is 'completed'
WHERE (date_completed BETWEEN '04/13/2010' AND '04/13/2010')
OR (date_due BETWEEN '04/13/2010' AND '04/13/2010')
OR (date_assigned BETWEEN '04/13/2010' AND '04/13/2010')
AND (empID = '55') AND (taskStatus = 'completed')