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

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

Guest

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!
 
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
 
Back
Top