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: k2j1203@yahoo.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar