By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,121 Members | 1,706 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,121 IT Pros & Developers. It's quick & easy.

Joining two table's in a Query

P: 1
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.
Mar 29 '12 #1
Share this Question
Share on Google+
1 Reply

Seth Schrock
Expert 2.5K+
P: 2,941
It sounds like you have a problem with database normalization. Read this and it will help you to get your database properly designed which will make this question a very simple problem.
Mar 29 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.