Recent content by Ambre

Hi, I have a table of data, Enrolments, that includes the columns, [DeptNo], [CourseNo], [LearnerNo] and [Gender] with a load of other data. The same [LearnerNo] can have rows relating to one or more [CourseNo]'s that might be in one or more [Dept]'s. I need a query that will return by...

Thank you for the tips. Such a lot to learn! The queries do now work if I have the form open first as you pointed out. Getting there. Sloooooooooooooooooowly

Hi, Thanks to everyone who has replied. I think I will go down the route of using a single table with an identifier on each record to indicate the batch of data it belongs to. This still leaves me with the problem of selecting which 'batch' I want to analyse. I have explored the idea of...

Hi, I have a bunch of queries that I need to run against a data table to produce various analyses. Every two weeks I get a fresh set of data, same structure, more rows. I import this data into the database with a different table name because I need to retain the existing table(s) for trend...

Hi, I have a table of enrolments. Each row is a single enrolments by a Learner on a course in a Curriculum Area. A Curriculum Area can have a number of different types of courses eg. CurrArea Languages offers French, German and Italian and a Learner could join one or more courses in any or...

Hi John, OK, here goes. Ambre

Hi John, I am struggling with this. Basically I don't know how to do what you ask. I have tried pasting screen shots into a WORD document (my usual approach) but the file size is too big to attach. Can I email you direct? Ambre

Hi John, I'm sorry it is not possible to share the database - Data Protection issues. Ambre

Hi, I work in education and have to work with 'Academic Years' that begin August 1 and finish July 31 the following calendar year. Academic Year Aug 07 to July 08 would be known as 2007. I need to query a database for Learners who are aged 19-25 on August 31 of the Academic year they...