Unbound textbox in an unbound report

[Blair]

I want to bind a textbox to a different query which has calculated fields.
Does the query have to be open? In the textbox control source I used the
expression builder to put this expression in
=[QWhelpingAverageReport]![CountOfFEMALE #]. When I view the report it comes
up #name? What am I doing wrong
Thanks Blair

 

[Al Camp]

Blair,
The query should be included in the query behind the report, so that that field is
available to the report.
In other words, *if there is a realtionship* between CountOfFemaleNo (don't use # in
field names, it's associated with Dates) and your other report data, then you should be
able to bring that query into the report query, form a realationship, and use place the
CountOfFemaleNo as a bound field..
If not related, then you'll have to use a calculated field with a Dlookup against
QWhelping.

 

[Blair]

Thanks I'll try the Dlookup

Blair,
The query should be included in the query behind the report, so that that field is
available to the report.
In other words, *if there is a realtionship* between CountOfFemaleNo (don't use # in
field names, it's associated with Dates) and your other report data, then you should be
able to bring that query into the report query, form a realationship, and use place the
CountOfFemaleNo as a bound field..
If not related, then you'll have to use a calculated field with a Dlookup against
QWhelping.

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

I want to bind a textbox to a different query which has calculated fields.
Does the query have to be open? In the textbox control source I used the
expression builder to put this expression in
=[QWhelpingAverageReport]![CountOfFEMALE #]. When I view the report it comes
up #name? What am I doing wrong
Thanks Blair