I have two table with i can’t seem to combined in a query
1st table has my employee's Id, last name, first name, task date and doc count
2nd table has my employee's id, last name, first name, date, and Index error's & the errors are in a yes or no, field
I’m trying to create a report that shows me the Employee’s id, last name first name, task date, doc count and index error's but only for a specific person and date range. The employee’s ids are different in both tables, and the 2nd table might have multiple records for the same day. ok so let say i want bobs doc count and index errors just for week 3/12/12 to 3/23/12, knowing he only has three errors on 3/21. I either get the doc count & index errors for the day he had error, or i get triplet of record of the doc count and three index’s errors for each day please if somebody knows of anything that could help please do.
1st table has my employee's Id, last name, first name, task date and doc count
2nd table has my employee's id, last name, first name, date, and Index error's & the errors are in a yes or no, field
I’m trying to create a report that shows me the Employee’s id, last name first name, task date, doc count and index error's but only for a specific person and date range. The employee’s ids are different in both tables, and the 2nd table might have multiple records for the same day. ok so let say i want bobs doc count and index errors just for week 3/12/12 to 3/23/12, knowing he only has three errors on 3/21. I either get the doc count & index errors for the day he had error, or i get triplet of record of the doc count and three index’s errors for each day please if somebody knows of anything that could help please do.
Comment