Complex Report [message #37364] |
Fri, 01 February 2002 21:27 |
Hem
Messages: 2 Registered: February 2002
|
Junior Member |
|
|
Hi I have created two tables...
Movies(MovieNo*, Title,YrMade)
Videos(VideoNo*,MovieNo,TimesRented, DueDate)
I want report as follows:
Movie Hire Summary Report for 2001
-----------------------------------
Movies --- Total
ABCD --- xxx
EFGH --- xx
Here total is Video.TimesRented There can be more than 1 video of a given movie. So I have to calculate all the video.TimesRented of a given movie in Videos table and then output as a report.
Need urgent help. WUd be appreciable
THanking you,
HEM
|
|
|
|