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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You can use the DLookup function in the Control Source.

Larry Linson
Microsoft Access MVP
 
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...
 
Back
Top