Queries in feilds

  • Thread starter Thread starter Ron Bromwell
  • Start date Start date
R

Ron Bromwell

Hi All,
I want to do a query from a text box on an access report.
I set the text box to = select count(*) from table
When I run the report I get #Name. The table I am querying
is different than query for the report. Does anyone know
if this can be done and if so how?

Thanks,
Ron
 
You cannot place a SQL statement into the Control Source property of a text
box.

Try a DCount instead, i.e.:
=DCount("*", "MyTable")
 
Back
Top