How to set up a spesific tablefield in the toptekst in a report

[itivar]

I trying to set up in the toptekst of a report the value that is in one
spesific field in one of the tables in the database. Is that possible?
Anybody got a hint?

 

[Evi]

Yes, if you have a way of indentifying the record that the field is in.
Put a text box in the Report's Header (is that what you meant by Top Text?)
and in it type
=DLookup("[FieldThatContainsValue]",
"TableOrQueryThatContainsTheData","[IdentifyingField]=2")
That's the rough idea. Of course, you will replace FieldThatContainsValue
etc with the real name of your field.
The formula I gave you looks up what is in a field called
FieldThatContainsValue. The field is in a Table or Query called
TableOrQueryThatContainsTheData.
I can tell which record has the correct value because a field called
IdentifyingField has the number 2 in it.

Tell us what type of data you want to look up. The DLookup formula changes
slightly if you are looking up a date or text.
Evi
#

 

[Wayne-I-M]

HI

I don't think you can refer to a specific record in the report unless you do
something like

if recordID = # then insert the .....

A simpler method may be to inbed a subreport and filter this on your criteria