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
|
|||
|
|||
Checklist Missing Items
Hello:
Sorry that this is a bit involved, but any help would be appreciated. I have an application that requires a checklist for salesmen. The list of checklist items is specific to a territory, so several salesmen will have the same checklist items. As a salesman accomplishes an item, we check it off. The tricky part comes in that we want to pull a list at any time of what the salesmen have NOT accomplished from the list. I started with table1 as a checklist master by territory. Then with table2 as a checklist table that holds the accomplished items by salesman: Table1: ChklistMasterID TerritoryID Item Table2: SalesmanID ChklistMasterID I can't figure out how to build a query that will show each salesman's missing items. Help! Thanks Steve |
#2
|
|||
|
|||
Steve,
What do you mean by "As a salesman accomplishes an item, we check it off". Where is this check off recorded? You show nothing in the tables that records this. So I can't see how you can determine what a salesman has or has not done. The tables that you show simply tell you what the salesman has to do. Something is missing. -- Chaim "Steve Happ" wrote: Hello: Sorry that this is a bit involved, but any help would be appreciated. I have an application that requires a checklist for salesmen. The list of checklist items is specific to a territory, so several salesmen will have the same checklist items. As a salesman accomplishes an item, we check it off. The tricky part comes in that we want to pull a list at any time of what the salesmen have NOT accomplished from the list. I started with table1 as a checklist master by territory. Then with table2 as a checklist table that holds the accomplished items by salesman: Table1: ChklistMasterID TerritoryID Item Table2: SalesmanID ChklistMasterID I can't figure out how to build a query that will show each salesman's missing items. Help! Thanks Steve |
#3
|
|||
|
|||
Hello Chaim:
Sorry for the lack of info. Table 2 holds the items that the salesman accomplishes. In other words, the "checking off" process means we write a record into table 2 of what the salesman has done. So, Table 1 holds the complete list for the territory and table2 holds what the salesman has done. I need to know for each salesman which items from table 1 are NOT in table 2. Is that clearer? Thanks Steve "Chaim" wrote: Steve, What do you mean by "As a salesman accomplishes an item, we check it off". Where is this check off recorded? You show nothing in the tables that records this. So I can't see how you can determine what a salesman has or has not done. The tables that you show simply tell you what the salesman has to do. Something is missing. -- Chaim "Steve Happ" wrote: Hello: Sorry that this is a bit involved, but any help would be appreciated. I have an application that requires a checklist for salesmen. The list of checklist items is specific to a territory, so several salesmen will have the same checklist items. As a salesman accomplishes an item, we check it off. The tricky part comes in that we want to pull a list at any time of what the salesmen have NOT accomplished from the list. I started with table1 as a checklist master by territory. Then with table2 as a checklist table that holds the accomplished items by salesman: Table1: ChklistMasterID TerritoryID Item Table2: SalesmanID ChklistMasterID I can't figure out how to build a query that will show each salesman's missing items. Help! Thanks Steve |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Extract New Items after comparing two different tables. | EaglesNest | Running & Setting Up Queries | 1 | March 14th, 2005 01:22 AM |
How to keep the first 24 items in the Clipboard intact for Words 2 | zquest | General Discussions | 0 | March 10th, 2005 01:57 AM |
Sent items do not refresh right away | TemporarilyConfused | General Discussion | 0 | March 3rd, 2005 04:31 PM |
Missing Calendar items | DotPC | Calendar | 1 | January 10th, 2005 08:17 PM |
Sent items rule, items disappeared | Shasta | General Discussion | 1 | October 5th, 2004 02:17 AM |