Query suddenly not working - any advice?

[Indigo]

I am working in Access 2003 and I have a query that is the source for a chart on a form. The query has worked fine for several years but suddenly it will not populate for the month of April. There is data in the source table for April, but the query is not showing it and I can't figure out why. Nothing in the table has changed.

My SQL for the query is:

SELECT qryKCYrMn.KCYearMonth AS Expr1, Sum(IIf(Format([StartDate],"yyyymm")=[KCYearMonth],1,0)) AS [# Opened], Sum(IIf(Format([ClosedDate],"yyyymm")=[KCYearMonth],1,0)) AS [# Closed]
FROM qryKCYrMn, qryKCFY12
GROUP BY qryKCYrMn.KCYearMonth
HAVING (((qryKCYrMn.KCYearMonth)>"201103"))
ORDER BY qryKCYrMn.KCYearMonth;

and the SQL for qryKCYrMn is:

SELECT Format([StartDate],"yyyymm") AS KCYearMonth
FROM KaizenCircle
GROUP BY Format([StartDate],"yyyymm");

I use a the very same query with another source table for a second chart on the same form and it works fine, no issues.

Any advice would be appreciated. Thank you.

 

[jdraw]

Can you post a copy of your mdb with enough data to show the issue-- take out anything confidential.

 

[Indigo]

Unfortunately, there are employee records in the database that I cannot delete as they are linked to what is being tracked. Can I attach screen shots to show the results?

 

[spikepl]

If your two queries worked before, with the same exact code, but no longer deliver what is expected of them for a specific segment of data, that means that the data is not as you expect. Verify your data.