Report asking for critera when run

[Johnny Drama]

Hi all,

I've built a simple report that uses a query to pull data. The report is supposed to display a audit name, the sum of the hours for the audit, and the budgeted hours. When I look at the query in datasheet view it runs fine, but when I point the report at the query to pull the data it asks for a criteria for the audit when the report runs. If I click OK it runs the report with the proper data, but I don't want anyone to be presented with the criteria box. Anyone have any idea why this is happening? The SQL for the report is below:

SELECT Audits.[Audit Name], Sum([Audit Hours].[Hours Worked]) AS [SumOfHours Worked], Audits.[Budgeted Hours]
FROM Audits INNER JOIN [Audit Hours] ON Audits.ID = [Audit Hours].Audit
GROUP BY Audits.[Audit Name], Audits.[Budgeted Hours];

Thanks

 

[Johnny Drama]

Never mind...the error was between the chair and the computer...ugh.