OfficeFrustration (
-   Setting Up & Running Reports (
-   -   Use SQL Statement In Report Text Box (

Jeff Monroe August 30th, 2011 11:35 PM

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.


All times are GMT +1. The time now is 10:30 PM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.