Drh
08-18-2010, 01:21 PM
Hi,
I have an unnormalised table that i cant alter the schema of. Its a sort of attendance register scenario for pupils attending classes:
Columns:
Student_id, class_id, week1, week2, week3, ..., week11
Ideally i'd like a calculated column to count for how many weeks the pupil has been absent (absence is denoted by a value "u" under each week, as appropriate).
This would be much easier if the database was normalised, but my union query and vba efforts cause cause the db to slow to a crawl.
Any thoughts much appreciated!
I have an unnormalised table that i cant alter the schema of. Its a sort of attendance register scenario for pupils attending classes:
Columns:
Student_id, class_id, week1, week2, week3, ..., week11
Ideally i'd like a calculated column to count for how many weeks the pupil has been absent (absence is denoted by a value "u" under each week, as appropriate).
This would be much easier if the database was normalised, but my union query and vba efforts cause cause the db to slow to a crawl.
Any thoughts much appreciated!