text box in a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top