Search results

Using multiple checkboxes in a search-form query??? Hi all, I really need some help - can anyone lend a fresh set of eyes and some advice? We have a youth club database. On each young person's profile they select checkboxes for what sessions they are available (e.g. MonAM, MonPM, MonEv...

Hi everyone, What is the chance that my database is slowly losing old data? We have a learner database used in a school setting. I've noticed for some time that reports don't always match up, despite covering the same period without changes (e.g. number of exams sat in October 2010 is...

Hi everyone, This is probably a very simple design flaw, but I've been pulling my hair out trying to fix it the last couple of days and I haven't had much luck! If someone could point out where I'm going wrong, it would mean a lot. Our database tracks the progress of learners on their...

Hey all, I'm having quite a bizarre time trying to add two columns together in a query - can anyone offer any advice? For the sake of simplicity, my query looks like: - [Course Enrolments].[Student Number] (Group by) - [Course Enrolments].[Enrolment ID] (Count) - Passes: NZ([Number of...

Hi all! Before I went on holiday, I played around and managed to produce a cross-tab query which counted up the number of learners who passed a course, and broke this down by Special Educational Needs (e.g. Number of students with dyslexia who got 1 pass, 2 passes, 3 passes, etc). For some...

I've noticed a number of peculiar looking auto-numbers crop up on our Student database system. It doesn't seem to be affecting performance of the system, but I am still concerned that this may lead to future problems. For example, 1.625E+03 has cropped up. At the moment I have only noticed...

Dear all, I have created a database system used to manage learner records. I am trying to measure progression (i.e. number of grades that a student goes up or down during their time studying with us) through a query - but I've hit a wall and could do with a fresh pair of eyes! Background -...

Apologies if this is something ridiculously easy - I'm new (but learning fast!) I'm putting together a student records system. The database is fine, working on three tables: 'students' , 'courses' and 'enrollments'. The forms, sub-forms and relationships all work beautifully; but I'm having...