I have a database of clients who are booked to attend particular events throughout the year. The database of client details is actually handled by another program, but I can send these details to an Excel spreadsheet.
I am looking for a way I can easily generate a list of attendees for each event, with all the client details (address, phone, etc) automatically populated. Can anyone talk me through the steps how to make this happen?? I have Excel 2007 and Access at my disposal.