Search results

Sorry, don't have 10 posts yet to be allowed to post pictures/URLS, so I edited my post with a description of the picture I wanted to post, haha. Is it sufficiently clear?

I'm trying to create a program to input student attendance. The interface I'm going for is an Excel-looking spreadsheet with: Columns as weekdays in a given month Rows as all students Cells as the attendance code (e.g., A for absent) for that day/student I have: Students Table with StudentID...

Hm, actually upon looking further into it, I'm not sure this is working for me. Crosstab queries seem to be read-only without some elaborate and not very elegant looking tricks, am I right? Unfortunately, my messy solution hit the same wall. Individual query tables for each day are editable...

Aha! Crosstab query. Man, that sure is useful. Thanks :)

Preamble edit: I'm running Access 2003. I have two tables, Students and AttendanceRecords. Students just has studentID and studentName AttendanceRecords has AttRecID, studentID, presence, thedate I'm looking to create what looks like an Excel grid, with the last 10 days as columns and the...

Thanks CJ_London! I ran into a sizeable problem while working on the radio button end of things I was hoping you could help me with: I currently have 3 tables. -Student (studentID, name, startdate and enddate) -AttendanceTypes (attTypeID, attType) -AttRecord (AttRecordID, studentID, attTypeID...

-Edit in advance: I'm stuck using Access 2003 so I can't look at certain sample databases and maybe don't have access to certain ways of solving problems- Hi all; I'm just starting to get into the nuts and bolts of Access so I'm worried some of the solutions I think up are needlessly...