Subform in Data Report

[MacChris]

Hi
It's maybe a dummy question but i need help to have something like a subform in my Data Report Form.
Situation: I've got a DB with a Table Name and a Table with Video
The Table Name contents - NameID -Surname -Name -Street
The Table Video contents - VideoID -Title -Author

Now I like to have a Report contains Data "SELECT tbl_Name.*, tbl_Video.* FROM tbl_Name, tbl_Video WHERE tbl_Name.NameID = tbl_Video.VideoID)

In the Report it shows all Information -Surname -Name -Street and in the lower sektion the VideoTitle Author. (so for so good)
when it's return more Recordsets then one it will displays all Data, one per Page. and here ist my Problem.
I need a Report who shows the Data of Name on top of the Report and in the middel Section all Video stuff on one Page.

can someone help me ?
regards
Chris

 

[MacChris]

MS Asscess DB with 3 Tables
tbl_Customer: with ID, CustomerNr, Name, Surname, Street, Country
tbl_Video: with ID, VideoNr, VideoTitle, VideoAuthor, VideoYear
tbl_lend: with ID, CustomerNr, VideoNr
tbl_Customer:NameID = tbl_lend:CustomerNr
tbl_Video:VideoID = tbl_lend:VideoNr
qry_Overview: SELECT tbl_Customer.* ,tbl_lend.* ,tbl_Video.* FROM tbl_Video, tbl_Lend, tbl_Customer WHERE tbl_Video.VideoNr = tbl_Lend.VideoNr AND tbl_Lend.CustomerNr = tbl_Custumer.CustomerNr
DataReport View should look like:

______________________________________________________

Videos Lend to Customer

Name Chritian
Surname Lehner
Street Zürich
Country Swiss


Video Title Author Year

Die Hard I Buck & Huck 1852
Die Hard II Buck & Huck 1855
Die Hard III Buck & Huck 1860

Total of Video lend 3

______________________________________________________

And this should be only on one Page !

Regards
Christian

 

[johnwm]

Do a search on the Shape keyword

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'

http://www.essexsteam.co.uk

for steam enthusiasts