Pull data from second table into report

[nmdonati]

I am trying to create a report that would be a sign-in sheet for employee
meetings. I am pulling employee names and data from a query, and that part
is fine. Here's where the trouble is: In the report header I want to pull
the meeting topic and date from another table called tblMeetingTopic. There
is no common data between the first query and this table, so I don't think I
can combine them into one query. Each time I run the report, I will specify
the MeetingTopicDate, and I want MeetingTopicDesc to populate.

The columns in tblMeetingTopic are:

MeetingTopicIdx
MeetingTopicDate
MeetingTopicDesc

Any help is appreceiated!

Thanks,
Nicole

 

[Allen Browne]

You could use a subreport that reads its data from this other table.

Or you could use a DLookup() expression in the text box. Here's more info on
how to do that:
Getting a value from a table: DLookup()
at:
http://allenbrowne.com/casu-07.html

 

[nmdonati via AccessMonster.com]

Thank you so much! The Dlookup worked. I had tried a Dlookup previously, but
I wasn't doing it correctly. You instructions were very helpful.

You could use a subreport that reads its data from this other table.

Or you could use a DLookup() expression in the text box. Here's more info on
how to do that:
Getting a value from a table: DLookup()
at:
http://allenbrowne.com/casu-07.html

I am trying to create a report that would be a sign-in sheet for employee
meetings. I am pulling employee names and data from a query, and that

[quoted text clipped - 18 lines]

Thanks,
Nicole