InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 15:55:41 GMT20http://www.sqlservercentral.com/Forums/Topic517212-23-1.aspxHiI think you need this kind of querySelect EmpId from employee where empid Not In (select EmpId from attendance where date = '2010-03-29')Tue, 30 Mar 2010 01:03:04 GMTshiningworld_4uhttp://www.sqlservercentral.com/Forums/Topic517212-23-1.aspxStill not giving enough info. Perhaps reading this will help:[url]http://www.sqlservercentral.com/articles/Best+Practices/61537/ [/url]:cool:Sat, 14 Jun 2008 21:50:51 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic517212-23-1.aspxtblEmployee, tblAttendance has one to many relationship... Here is a sample form in vb 6.0 what am i usingSearcy Options:StartDate End DateFilter those employee's who have taken consecutive absences and from what date it is...Sat, 14 Jun 2008 21:43:02 GMToliver8615http://www.sqlservercentral.com/Forums/Topic517212-23-1.aspxYou really have missed part of what I asked for earlier. The definition for your tables, some sample data for the tables, the expected output based on the sample data, what you have done so far to solve the problem at hand, and where you are having trouble getting what you want as an answer (the expected results based on the sample data).I could shoot in the dark all night and not help you solve your problem. You have to help us help you by providing as MUCH information as possible.:cool:Sat, 14 Jun 2008 21:35:37 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic517212-23-1.aspxI am using MS VB 6.0 so far i did was to search those employee's who have not take an attendance for a day.. my query for that is...Select EmpId from tblEmployee not IN (select EmpId from tblAttendance where [date] =#06/06/2008#)my problem for that is i want to know those employee's who have take a consecutive absences using two dates...Sat, 14 Jun 2008 21:18:15 GMToliver8615http://www.sqlservercentral.com/Forums/Topic517212-23-1.aspxAnd this helps us know what you've done so far how? Please reread my post and Jeff's post. Based on the information you have provided us so far, we can't help you. As I stated earlier, as this is a school project, you need to show us what you have done to solve the problem. We aren't going to just give you a solution. That would not be right, nor fair to you.:cool:Sat, 14 Jun 2008 20:31:44 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic517212-23-1.aspxI am using a Visual Basic 6.0 and a Microsoft Access database..Sat, 14 Jun 2008 20:13:30 GMToliver8615http://www.sqlservercentral.com/Forums/Topic517212-23-1.aspxTo add to what Lynn has already stated - I think you need to lookup OUTER JOIN's. Once you have posted additional information about the problem, I am sure someone here can help you further.JeffSat, 14 Jun 2008 20:04:35 GMTJeffrey Williams 3188http://www.sqlservercentral.com/Forums/Topic517212-23-1.aspxWe'd love to help you with your school project, but it would be better if you showed us what you have already done to try and solve the problem and what the issues you are having with your code.We'd also need to see the DDL for the tables, some sample data, and what the expected output would be based on the sample data.The reason for all this is to help you learn. We can look at what you have done so far, point out areas where you are having issues, and show you better ways of doing things. What we don't want to do, is do your work for you. That wouldn't be right, or even fair to you.:cool:Sat, 14 Jun 2008 19:59:08 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic517212-23-1.aspxgood Day... i need help about my project in school about employee attendance module. I have a table tblEmployee(EmpId,Name,Dept,Position) and another table tblAttendance(EmpId,date,AmIn,AmOut,PmIn,PmOut)I need a query that will find those employees who are absent or those employee who does not have an attendance on a specific date... urgent please thanks a lot....Sat, 14 Jun 2008 19:49:52 GMToliver8615