DLookup or LookUp Table to Show Data in a Report - Access 2007

[Lara]

I have a table with personal information and a flight code. I have another
table with the flight codes matched to flight numbers, airlines, and
departure times. I would like to print a report sorted by flight code but
show the flight number as the group header. I tried setting it up with lookup
tables, but got an error when trying to use the field in the report. I also
tried dlookup in a text field in the report header but kept getting one value
for the result rather than the one that matched the value of the field in
each section.

Thanks!

 

[tina]

link the two tables in the report's RecordSource, either directly or in a
query that you use as the RecordSource. then you'll have the fields
available without resorting to a domain aggregate function.

hth