Calculate number of hits

[Anonymous]

Hi

I have a table that shows each employee and average pick rate pr 10 min.

i.e:

Employee	09:00	09:10	09:20	09:30	09:40	09:50	10:00	10:10	10:20
Emp1	-	23	27	22	33	-	23	32	-
Emp2	-	34	30	19	-	-	-	34	21
Emp3	22	29	20	33	-	30	23	-	-

I need to create a second table that gives me the number of slots when empXX actually picked

Employee	Picks
Emp1	6
Emp2	5
Emp3	6

Any easy way to solve this?

BR

Dan

[Anonymous]

Tried that but not the result I needed.

field notation:

usr = userid

slot date= dategroup

nnumber: qty

I then tried:

Count(If(not isnull(userid),userid)) but the result is 49.

Should be 10

[#3]

try it with isnull(userid) = 1 that means not null and usually works i always have problems with the not hope this helps

regards,

MT

[#4]

sorry isnull(...) = 0  my mistake