Sales Rep and Service Tag both using same data of Employee Table. Now I need Query based on Customer Table that show Employee name who have engaged with customer either by Sales Rep or by Service Tag. So Employee will get whole chart that he is connected to which of customer. If I make a Query based on Customer Table and add only customer name , Sales Rep and Service Tag and giving employee name in Criteria to Sales Rep or same name to Service Tag with any one of employee name , than it shows error.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 10.