Query Not generating Chart in report

[jj1]

Hi I am trying to run simple query make a chart in report through this query but its not generating chart? Can anybody help?

SELECT [Unsafe Act Unsafe Condition].[Inspection Audit], Count([Unsafe Act Unsafe Condition].[Inspection Audit]) AS [CountOfInspection Audit]
FROM [Unsafe Act Unsafe Condition]
WHERE ((([Unsafe Act Unsafe Condition].Date) Between [Forms]![frmSafetyReportOut]![startDate] And [Forms]![frmSafetyReportOut]![endDate])) OR ((([Unsafe Act Unsafe Condition].Department)=[Forms]![frmSafetyReportOut]![cboDepartment]))
GROUP BY [Unsafe Act Unsafe Condition].[Inspection Audit]
HAVING ((([Unsafe Act Unsafe Condition].[Inspection Audit]) Is Not Null) AND ((Count([Unsafe Act Unsafe Condition].[Inspection Audit])) Is Not Null));

[rpeare]

Does your query show any results. Not the graph, the query behind the graph?

Have you got a sample database you can upload, it will be hard to diagnose this problem without some sample to work with.

If you want to create a sample database, make a copy of your database, get rid of any private information, put enough junk data in to simulate the problem, then compact/repair, zip the file and upload it using the GO ADVANCED button at the bottom right of the posting area.