Add a particular record from a table to a report text box

D

Dirty70FireBird

I have a report that is generated from a query. The record that I would like
to add does not come from the same table and query that generates this
report, but from another, seperate table. I ultimately will use this value
as a constant in a calculation on the report. I started to use an SQL
statement in the control source section of the text box, but I get a "No Such
Field in the Field list" error.
This is my SQL code:
Select [MaxLimit] From Tables![LimitTable] Where TestNum = 10
Where MaxLimit is the record (or column of the LimitTable table), LimitTable
is the table, and TestNum is the record (or Row in the LimitTable Table)

Am I going about this the correct way? TIA
 
L

Larry Linson

You can use the DLookup function in the Control Source.

Larry Linson
Microsoft Access MVP
 
D

Dirty70Firebird

Thanks Larry!
I'll Give this a shot!

Larry Linson said:
You can use the DLookup function in the Control Source.

Larry Linson
Microsoft Access MVP

Dirty70FireBird said:
I have a report that is generated from a query. The record that I would like
to add does not come from the same table and query that generates this
report, but from another, seperate table. I ultimately will use this value
as a constant in a calculation on the report. I started to use an SQL
statement in the control source section of the text box, but I get a "No Such
Field in the Field list" error.
This is my SQL code:
Select [MaxLimit] From Tables![LimitTable] Where TestNum = 10
Where MaxLimit is the record (or column of the LimitTable table), LimitTable
is the table, and TestNum is the record (or Row in the LimitTable Table)

Am I going about this the correct way? TIA
Click to expand...
Click to expand...
 
Top