Recent content by Paine

Any takers? Still haven't solved it! :)

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...

Thanks - I amended the record source and basically pulled all the fields through from a form. This works fine now! :-)

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...

Every time I come on this forum I discover new things that I never knew existed - thank you CBrighton :)

I'm not sure that would work here. if I use 1 as null then that will mean every learner who has not yet finished their course will have "1" pass. In reality they have 0 passes because they have not completed yet... Using IIF I have managed to convert these achievement rates back to null where...

OK, we're limping across the finish line now! I didn't have any luck getting Val() to work and I think I was being too complex with what I was trying to achieve in the one query, so, I have created a second query which reads off the first query and does the very simple formula, ie it looks...

PS: apologies vbainet, only just saw your response - perhaps I should use Val() to tidy it up once I've worked out where I'm going wrong here!

OK, I've managed to get the total column. So, if I have to do the achievement rate in full then should it be.... Achievement rate: (CInt(NZ([Number of passes per learner].[Passes],0))/(CInt(NZ([Number of passes per learner].[Passes],0))+CInt(NZ([Number of fails per...

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...

Thanks, that's a really handy formula - I've gone through other queries and used it to improve results. I'm particularly pleased because combining it with Date() in a sum has allowed me to work out the total number of days that a young person has been with us. But, it does seem to have a...

Right, I've made a lot of progress - perhaps too much because I've started being overambitious again! I've created a query, called Enrolment Analysis, which has: [YP ID] [Name] [Surname] [DOB] [Special Needs] [Ethnicity] [Enrolments] (counts [enrolment ID]) [Passes] (result from another...

Thanks Jdraw, it was so simple!! I've just been overcomplicating things. Now I know how this is done it is going to really help, thank you very much.

Thanks Jdraw,I've not used SQL before, I've been using the queries - how would this be structured in a query? (But I shall have a play around and let you know if I suss it out!)