there is a query "count" that is not summarizing data in the table correctly. Fix the query must be a fix inside the query no vba nothing like that .... there is also added "true count" query for lets say 76+ days you will see its short by 15 days ... why ? why is "count" query not able to capture everything?