If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
query to locate which record was not added
Hello,
will try to explain. i have 4 employees. jim, jack, joe, and john. every week a report is created that needs to have one record from each of them. But they are not responsible and may forget to submit data. first week Table1 name endDate Jim 2/6/10 Joe 2/6/10 John 2/6/10 * Jack forgot to turn in his report* Is there anyway to find this out with a query? sql statement? you may say -you can see easy with 4 records - who is missing- but with 50 names and if it was 49 entries it will take longer to find name not there. I am able to count the records and display on report - but I am being asked to provide names of people not on report Does anybody know if this can be done in a query? also any helpfull advice to solve this will be helpfull - using my example to go from thank you -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/201002/1 |
#2
|
|||
|
|||
query to locate which record was not added
On Wed, 24 Feb 2010 02:43:57 GMT, "buddyr via AccessMonster.com" u57883@uwe
wrote: Hello, will try to explain. i have 4 employees. jim, jack, joe, and john. every week a report is created that needs to have one record from each of them. But they are not responsible and may forget to submit data. first week Table1 name endDate Jim 2/6/10 Joe 2/6/10 John 2/6/10 * Jack forgot to turn in his report* Is there anyway to find this out with a query? sql statement? you may say -you can see easy with 4 records - who is missing- but with 50 names and if it was 49 entries it will take longer to find name not there. I am able to count the records and display on report - but I am being asked to provide names of people not on report Does anybody know if this can be done in a query? also any helpfull advice to solve this will be helpfull - using my example to go from thank you I presume you have a fifty-row table of Employees... right? If so, create a Query selecting the records for the desired date range from Table1. Then use the Unmatched Query Wizard to create a query joining the Employees table to this query. Of course Jack is having the time of his life on a vacation to a ski chalet in Switzerland, so it's ok... g -- John W. Vinson [MVP] |
#3
|
|||
|
|||
query to locate which record was not added
thanks for the help
John W. Vinson wrote: Hello, will try to explain. [quoted text clipped - 23 lines] go from thank you I presume you have a fifty-row table of Employees... right? If so, create a Query selecting the records for the desired date range from Table1. Then use the Unmatched Query Wizard to create a query joining the Employees table to this query. Of course Jack is having the time of his life on a vacation to a ski chalet in Switzerland, so it's ok... g -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/201002/1 |
Thread Tools | |
Display Modes | |
|
|