Report text box using a 2nd data source?

  • Thread starter Thread starter Steveo
  • Start date Start date
S

Steveo

Server = MS Win200 SP4 + SQL Server 2000 SP3
Client = MS Win200 SP4 + Access 2000 SP3

I have a report in an Access 2000 Data Project, with a
view as its data source.

In theory is it possible to have a text box who's data
source is a select statement getting a piece of data from
a table which is not part of the reports main data source?

eg

Report Main data source is a view which is basically

select
year,
month,
code
from table

Then have a text box on the report which is

=(select note from table_of_notes where year = '2003' and
period = '12' and code = 'A1000')

At the momment the main section of the report runs fine
but the text box returns #Name?

Before I establish if I'm doing something wrong, I just
wanted to check if a report can get data into a text box
using a select statement which targets a table not in the
main data source of the report?

Hope that made sense :)

Thanks.

Steve'o
 
A great idea, I would never have thought to use an entire
report to act as a single text box.

Worked a treat! :)

Many thanks.
 
Back
Top