Karen-
Clear as mud. 😃
What defines an available sales rep? Is the rep available if there is no activity logged for the specified date?
What is in tblRepsCmbd? It seems strange that you have outer joined this with activities, yet it has a rep name in it and no department info. Isn't there a separate table that lists all reps and their departments?
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Jul 26, 2015, at 10:37 PM, k2j1203@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
Hello everyone. I hope everyone is doing well. I'm stuck on a query that I'm trying to create.
I want to create a query where an user can type in a date and department and have the query results be all of the sales reps that are available for that date. I have two tables: tblActivities and tblRepsCmbd. They are left joined on tblActivities.ActivityID_PK to tblRepsCmbd.ActivityID_FK. The field that I want to have the user enter the date is tblActivities.ActivityDate. The field for department is tblActivities.Dept. The sales reps names are in tblRepsCmbd.RepName field.
Let me know if you need more information.
Thanks so much.
Karen
__._,_.___
Posted by: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar