title: Cells appear the same but don't match in MS Access
body: <p>I'm using sum to give me the percentages of each category I have in a column called Time Weekdays. I know that's bad spelling protocol but I didn't create that. This is what I'm using for each query:</p>
  
  <p><code>Sum(IIf([Time Weekdays]=("4-5 h/day"),1,0))/Count(*) AS [% 4-5h/day]</code></p>
  
  <p>The problem is I found that my percentages across all the categories were not adding up to 100. I realised when looking at the filters on my table that certain cells are coming up as two different categories even though they appear to be the exact same.</p>
  
  <p><img src="https://i.stack.imgur.com/fGqXm.png" alt="enter image description here"></p>
  
  <p>Any idea what might be going wrong?</p>