I believe the root of the problem is how you're defining your fields in
Access. If you want to attack the problem there, you need to review your
field definitions; you may need to experiment. I also encountered this when
exporting from Access to Excel. I can't recall the details of my situation,
but I found that making some change to the field definitions solved the
problem.

David

"Chrism" wrote in message
ups.com...
Does anyone know why? Or how to make that happen w/o retyping all 200
numbers (employee numbers) multiple times on the list? I know that
when I retype the numbers then the formulas can 'see' the number and do
the calcualtion, but not if I don't retype. The formats are the
same(number).

A C Z AA
1 EmpNo Units Empno Ttl Units
2 77 7 77 10 =SUMPRODUCT(Empno=Z2)*(units))
3 77 1 9533 11
4 77 2 10058 14
5 9533 7
6 9533 1
7 9533 3
8 10058 6
9 10058 2
10 10058 3
11 10058 3

Any and all help would be greatly appreciated

Thanks
Chrism