View Single Post
Old August 30th, 2011, 11:35 PM
Jeff Monroe Jeff Monroe is offline
First recorded activity by OfficeFrustration: May 2006
Location: San Diego, CA
Posts: 27
Default 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.


Last edited by Jeff Monroe : August 30th, 2011 at 11:47 PM. Reason: Add Notifocation