I'm not sure how to do this report (or even to pull the data for that matter) Here are my basic tables:
<Rental>
Rental ID, MemberID, DateOut, DateIn, Notes
<Rental_Movies>
Rental ID, TitleID
<Rental_Music>
Rental ID, TitleID
<Movies>
ID, Title
<Music>
ID, Title
<Members>
ID, Last, First, ...
Note: some fields are left off for Brevity.
I want the report to look something like:
RentalID Last, First DateOut DateIn
Notes
List each movie matching RentalID
Movie_Title
List each music matching RentalID
Music_Title
I can get it close, but it interleaves the Music with the Movies which I dont want. I am currently pulling all the data through left joins,
Thanks
Peter