overlaping fields

[programmingmiss]

I have a table with a field type employee type (text):

It has values of: P or PF

employee type = P (pension (some)
employee type = PF (pension, full)

When I do a simple sort of data in the table , the #s don't add;

When I select P AND! PF, I get 7,000, and
only F = 4,000,
but just P and I get a larger number than 7,000 (the value of BOTH P and PF) total. Any thoughts?

Thank you!

 

[programmingmiss]

I solved it; need to clean the data.................thx!!