Skip to Content
0
Former Member
Mar 17, 2009 at 03:28 PM

Report with Sub Reports?

30 Views

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