SQL statements in text box

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
 
F

fredg

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.
 
M

Marshall Barton

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