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

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!
 
T

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DLookup can't find a value 13
Dlookup in Detail 7
Dlookup and my ignorance 5
Doing a DLookup in a report 3
Number of Pages in a Report Section 1
Date Query to create a report 1
dlookup based on first digits of a field 3
how to save a calculated field in a form to a table 3

Top