AnsweredAssumed Answered

Create a value list of active employees only

Question asked by Dees on Jun 19, 2013
Latest reply on Jun 20, 2013 by philmodjunk

Title

Create a value list of active employees only

Post

     I have a table that contains the following fields:-

     EmployeeId

     FullName

     Status

      

      

     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

     Amount

     Date

     EmployeeId

      

      

     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

      

     Dee

                
               Preferences
§
1
2
3
4
5
6
7
8
9
0
-
=
Backspace
                     
Tab
q
w
e
r
t
y
u
i
o
p
[
]
                          
Return
                          
                     
capslock
a
s
d
f
g
h
j
k
l
;
'
\
                     
shift
`
z
x
c
v
b
n
m
,
.
/
shift
                     
                          
                         English
                               
                               
alt
alt
                     
                
               Preferences

      

Outcomes