Roll book type form / report

[iamkagy]

Hi All,
I'm trying to create a roll book database, I think I have the data structure okay, but I'm having trouble creating the "2d table" layout form. The problem is that the headings aren't fields but data from other records.

What I want to display is

                   1-6-11     8-6-11     15-6-11 ......
Student1          1             0               1
Student2           1            1               1
etc

The relevant info from the tables is

tbl_students  ---               tbl_attendance            ---           tbl_class_instance
Name etc       |      link stud_id  / link_class_id         |         date / location /etc

I don't really want to go with the option of fields called Class1, Class2 etc as courses are of different lenghts
Any pointers in the right direction would be appreciated, it's difficult to Google for something like this!
Thanks in advance,
Karl

 

[JamesMcS]

Hi, welcome to the forum!

It looks like you're trying to create a crosstab query there, am I right? Or is it static values that you want at the top of your form? Not quite sure from your description... could you upload your DB, minus poersonal data, so we can have a look?

 

[iamkagy]

Hi, welcome to the forum!

It looks like you're trying to create a crosstab query there, am I right? Or is it static values that you want at the top of your form? Not quite sure from your description... could you upload your DB, minus poersonal data, so we can have a look?

Thanks! Yes the dates I want at the top are dynamic. I knew I was missing something basic, it's been years (Access2000!?!) since I last tried to create a database.
It's a personal project, only on paper at the moment, an evolution from a spreadsheet that was getting unwieldy, but as I progress I post updates.
This was the blocking issue so I'll work on that first and post a sample here for others to see. (But don't hold your breath, plenty of other projects on too!)