Add a field to a report built from another table

[KaiserSose]

When trying to add fields to an existing report I find that those feilds are
not available in the list. There must be a way to access fields from this or
other tables. Note this is a SELECT DISINCT REPORT.

 

[Duane Hookom]

Field values can be add to a report by
-adding tables/queries to report's record source query
-use domain aggregate functions like DLookup()
-use controls with Row Source properties
-use a subreport
-use code to set the values of unbound controls
-write and use a function that returns the value

 

[Larry Linson]

When trying to add fields to an existing report I find that those feilds
are
not available in the list. There must be a way to access fields from this
or
other tables. Note this is a SELECT DISINCT REPORT.