Current situation: 5 employees enter information in individual Access databases. They print a report then turn it in to Admin who has to type in all of the information in her main database to print a report for meetings. SMH.
What I need help with: The goal is to link all of the external tables with the Admin's database so that she can print one report using data that the 5 employees entered.
I don't know how to link then report using data from all of the tables. The common field in all of the tables is [meetingdate]. The Admin's query should ask for the [meetingdate]
I hope this makes sense and you can help...