Use SQL Statement In Report Text Box
In Access 2007 I have a report where I would like to use a SQL statement inside a text box's control source. In the text boxes control source I copied the SQL statement from a query:
SELECT Count([tblBasic Info].Complaint) AS CountOfComplaint
FROM [tblBasic Info]
WHERE ((([tblBasic Info].[Complaint State])="Registered")) OR ((([tblBasic Info].[Complaint State])="Investigation"));
When I run the report I get the Name? error.
Is it possible to to this?
I am trying to avoid writing several queries that each have one data point (a summary of data) and placing them in the report as several sub-reports.
Thanks.
Jeff
__________________
jm
Last edited by Jeff Monroe : August 30th, 2011 at 11:47 PM.
Reason: Add Notifocation
|