SQL statements in text box

  • Thread starter Thread starter Keith
  • Start date Start date
K

Keith

Hi all;

Can SQL statements be place directly into the Control
Source property for a text box on a report? I'm
attempting to extract data from a select query.

Thanks in advance,
Keith
 
Hi all;

Can SQL statements be place directly into the Control
Source property for a text box on a report? I'm
attempting to extract data from a select query.

Thanks in advance,
Keith
Click to expand...

No!
But you can use a DLookUp() in the control and reference one field in
the query.
 
Keith said:
Can SQL statements be place directly into the Control
Source property for a text box on a report? I'm
attempting to extract data from a select query.
Click to expand...


No, you can not do that. You can use a DLookup to retrieve
a single value from a table. The usefullness of that
depends on what you trying to accomplish. It is far more
common to join the table into the report's record source
query.
 
Back
Top