Just Wondering?

[Golfinray]

Is there a way to put a text box in a report from a table not in the field
list and only have one field show. In other words, I tried putting control
source of the text box
=[district table]!school. That does not work. I can just put =district
table and all the fields in district table come up but I just want the one.
Help!!! Thanks so much!!!

 

[George Nicholson]

If you just want to pull a single value out of a table, you can use
Dlookup(), etc. just like you would on a form or in code. Not sure what your
criteria is, but something like:

"Display the School name from DistrictTable Where SchoolID = somevalue"
translates to:

= NZ(Dlookup("[School]","[District table]", "[SchoolID]= " & somevalue),"")

Ive wrapped Dlookup in NZ so that if the value is not found, the returned
Null won't throw an error.