Search results

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!)

OK, let's keep this simple. Does anyone know how I would go about counting the number of passes that each learner has? From there I should be able to do more complicated things. I've tried adding a SumofPasses: Count((E).[Outcome]) column to the query above but this gives me an answer of 1...

I wonder if this is what I need? We use Access Viewer here, so navigation has to be done via forms (no access to tables or queries). If our staff want to generate a report at the moment, they have to ask me to copy the database on to memory stick and amend the queries using Access 2007 on my...

Thanks Gina, much appreciated! You're right, we're not too bothered about what an autonumber looks like because they're just functional. I was worried that perhaps the system was developing some sort of fatal error, but if this is a normal thing then that's great news for us! :D Steve

That's a very interesting question. I went on to the form in design view, navgated to the subform and selected properties for the enrolment ID. Under data, the Text Format is 'plain text'. Under Format it was blank. I changed this to 'General Number' but the problem still seemed to happen for...

Hi John, I came across that article whilst looking through the internet for solutions. Our Jet service pack is up to date, we haven't been appending data from one table to another, and I'm not sure there is a problem with our form / subform relationship because they use linking data between...