![]() |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
![]()
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 |
Thread Tools | |
Display Modes | |
|
|