Hey,

for some days i've a problem with an Access-Query and up to now i didn't succeed to find an answer, i'm not even sure if there is one.

So, how to explain my problem.
I'm trying to compile a Database for my small department to organize our computer-short-course
students (application, grades, attendance...)

And with the grades i have a problem as well as with the attendance. Up to now we are just using paper sheets for grades and attendance. So i just thought that it would be the easiest thing to create a similiar-looking form, drawing of planned Query-output-layout is attached.

The attendance should be set with a checkbox. New days are set with a small subform.
For the attendance i've this table-layout:

tblAttendance
aSID
aCID
aDate
aPresent

When a new day is set, every student gets a new record at the tblAttendance, which shall be compiled together for the later Attendance Form.

So now the big question comes, is it possible to create
a query that fits my needs (variable amount of days and students and the possibility to set my records)? It is important that i've a big sheet with all the days, students of a course
at the same time.

Any suggestions - i'm completly lost.
Thanks in advance,
protos

Hey,

for some days i've a problem with an Access-Query and up to now i didn't succeed to find an answer, i'm not even sure if there is one.

So, how to explain my problem.
I'm trying to compile a Database for my small department to organize our computer-short-course
students (application, grades, attendance...)

And with the grades i have a problem as well as with the attendance. Up to now we are just using paper sheets for grades and attendance. So i just thought that it would be the easiest thing to create a similiar-looking form, drawing of planned Query-output-layout is attached.

The attendance should be set with a checkbox. New days are set with a small subform.
For the attendance i've this table-layout:

tblAttendance
aSID
aCID
aDate
aPresent

When a new day is set, every student gets a new record at the tblAttendance, which shall be compiled together for the later Attendance Form.

So now the big question comes, is it possible to create
a query that fits my needs (variable amount of days and students and the possibility to set my records)? It is important that i've a big sheet with all the days, students of a course
at the same time.

Any suggestions - i'm completly lost.
Thanks in advance,
protos

I would suggest creating a small database with appropriate tables;
a form or 2 for dialog and data entry;
and a form to display various reports/Forms based on some queries.

I don't think replicating the existing paper form is the best start.

Here's a reference that should help.

http://r937.com/relational.html

Okay, thanks for the reply. I'll have a look at it, but after all is it possible what i want to create?