Help

[Chris Lynch]

I have a database with three link tables. Student, Class and Attendance tables. the student holds studentnames and id(primary key) the class hold classnames and id(primary key). the attendance is then used to recieve data from a vb program. The attendance table holds, student id(foreign number), class id(foreign number), time/date and whether or not the atudent has attended class.

So in my student table i can expand any student and look at their records. is it possible to only put this data in a report?

 

[oldaf294]

control source

Chris, you might try creating a new report, copying the control source of the form and pasting it in the control source of the report. then position the fields as needed.
jim

 

[Chris Lynch]

Thanks but while i was waiting for a reply i found a way to do it using a query...

Thanks Anyway