text box in a report

P

Purnima Sharma

I want to put a text box in a report which should display the count of
records from a different query (which is in the same database). Is there a
way to achieve it without linking the table?. I put a select statement in the
control source property. It doesn't give any error but displays Name# in the
text box. How can I fix it? Thanks for your help.
Purnima
 
M

Marshall Barton

Purnima said:
I want to put a text box in a report which should display the count of
records from a different query (which is in the same database). Is there a
way to achieve it without linking the table?. I put a select statement in the
control source property. It doesn't give any error but displays Name# in the
text box.
Click to expand...


Control source expressions do not understand SQL.

Use the DCount function.
 
Top