Subquery on Report

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

Guest

I put a textbox in my report details.
I want to select a piece of data from a table based on a piece a data in the
row detail. How do I put that in the data source?
=(select CatName from tableCategories where CatID=reportfield)
This format does not work.


What happened to the Expression Builder in Acces 2002?
 
Paul:

1.) You can't set a control's control source = to a SQL string. You can
however, use the DFIRST and other domain functions as a control source which
should get you to about the same place; to reference another control on the
report, the use the syntax
[Report].[ControlName].
2.) Hating to use the domain function like that; wouldn't it just be easier
to add the table that you want to reference in the report's underlying
query? Alternatelly, use a subquery in the reports query to pull the data
into a field there.
3.) There's a replacement Expression builder available at Mike Kaplan's site
http://www.trigeminal.com/

HTH
 
Back
Top