Filter and Query Records Mismatch

A

Ayo

When I perform a filter on a table I get 371 records but when I design a
query based on the same criteria, I get 63 records. And the result in my
report is not showing the correct data based on this. I can't figure out what
I am doing wrong. Any help will be greatly appreciated.
Thanks.
 
Top