Queries in feilds

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
 
A

Allen Browne

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Creating a Chart on form from selected data in query. 0
Weekly Report 2
Possible to Combine reports to's to a single box? 0
Can I save a sql statement generated by a search form? 1
Link a text box based on drop down box with four options MS Word 365 0
A03 - count in report footer gives me #Error? 0
How to display zero value in blank fields of Cross Tab query 0

Top