Exporting Many-to-Many Relationship Records in Separate Tables to Excel Spreadsheet?

[warrenpage]

Hello, I need some help exporting records to an Excel spreadsheet. I'm using Access 2013.

My movie collection database currently has 117 records, to start off. I want to export the records to an Excel spreadsheet. I know how to do this, except for one thing: I cannot export the actors information.

The main table does not have fields for actors. There is a many-to-many relationship between the movies and actors.



The actors are in a separate table, linked to the main table via a junction table.

tblMovies
MovieID *
Title

tblActorsJunction
MovieID *
ActorID ++

tblActors
ActorID ++
ActorLastName
ActorFirstName
ActorFullName (calculated field)

(The asterisk and plus signs indicate the relationship joins.)

So..can anyone please tell me if it's possible to export the Movie ID, title, and actors' last & first names, if the actors are not in the main table?

If it is possible, what is the procedure? Thank you! Warren Page

[warrenpage]

I figured out how to do this a few minutes after posting the original question above. I just did a simple query, using the three related tables and fields . That got the actors into the table, and I successfully exported the data to Excel.