multiple criteria

[Daryl2106]

Hi,



I am trying to select records if they meet two criteria.

Here goes: Students in my school can continue in the same course from year to year if they don't finish in the year they enrol. However when they return the same course (e.g. subject, faculty, section) is given a different course number (not my decision and can't be changed). As such, some student will have two records for the same course identified by a year code (lets say 2011, 2012 or 2013, etc). The data from the previous year is carried over to the new course record each enrollment year.

To print report cards it is easy to select only records from the cureent year (these are records or courses that students are currenly active in). However if they finished a course in a previous year (% complete = 100), I need to be able to how that record too.

I am thinking that something like the following is needed but I am not sure how to go about it. I would prefer to be able to create it in the query design pane. I already have the field "Enrollment year" set to "2013".

I need to SELECT % complete=100 FOR Enrollment year <=2012

Thanks and take care,

Daryl

[AlexHedley]

Criteria in the Query builder can be built with multiple criteria either going along which is AND (in the same row) or down OR (use separate rows)

Add the criteria for each field accordingly.

- - -
Possible SQL:

SELECT * FROM table WHERE [complete]=100 AND [Enrollment year] <=2012

Change table to your Table name and check that the [fields] are the correct names.

[rpeare]

what is your dataset like, are you actually recording the % complete at the end of the term? or do you have a simple checkbox (or other method) that indicates whether the course is complete?

What I think you're trying to get at is this, show all students who:

1. Started and completed the class in the current term
2. Started the class in a previous term and completed this term

OR

Are you more interested it saying
student x started English 101 in the fall term of 2013, but finished in the winter term of 2014 and showing the grade at the time of completion, in other words showing the starting term and the final grade, regardless of term.

[John_G]

Hi -

Your difficulty is going to arise in identifying the same course in different years - you said the course number changes. Unless you have some part of the course description data that is the same from one year to the next, it will be very difficult. If the year is part of the course number, and only the year part of the number changes, it will be a lot easier.

Can you give an example of what your data looks like?

John

[Daryl2106]

Hi Everyone,

Thanks for your input. I was able to select the correct records by using "=100" for the progress field and courses with the current enrolment year from the the list of courses. I am worried that if a student completes a course in the current year howvwer it will select the record twice: once based on the completion percentage (100) and again based on the year code.

I will leave the thread open since we will be printing report shortly and it will surly be caught if it is so.

Take care,

Daryl