Creating report with data from two forms

Creating report with data from two forms

Can we make reports with two forms.

1.  I have student Form,

2.  Attendance form in which we enter day-wise hours attended and payable hours and
3.  Payment Collection form in which we enter course wise and month wise payment         details.

We want to see in one report

Student wise, course wise total hrs attended in a month  and collection from every student in that month to see who have not paid corresponding to hrs. attended.

Pls advise how this can be acheived.