Create a value list of active employees only
I have a table that contains the following fields:-
This table contains employees that are active and inactive. I want to create a value list that displays only the active employees. How can I do that?
Also I want to create a chart using the active employees and sales made by the employee per week. The sales table contains SalesID
How can I create a chart that uses a time frame of a week and uses only the active employees from the employee table gets the sale amount from the sales table and charts it.
Thanks in advance