Search results

try adding Nz(Jan,0) + Nz(Feb,0)....

for me I think you approach this in several ways. I would try to have a datasheet view with the student drop down at the top of the form. Then the datasheet fills with the classes that student has signed up for alreay or already has taken in reverse order of taken. So the last course taken is on...

just look online from google.. Dsum() and Dlookup should be easy for you to figure out.

what I normally do is in the table that you have that sets course or class put a number field there that is like a maxstutdent. Then every time you add a student to the table either at before Insert or After update. dsum() to check how many you already have and check it against that number from...

in the classes or maybe call it Class2Student table. Create a record for every student that takes or is trying to enroll in a class. Then in that table add dates fields to track the enrollment process example add LetterSentDate field. If you sent a letter then it have a date. If you haven't yet...

i was looking at your diagram. I would keep student, Course, Tutor, but I would think of it a little different possibly. take out the course tutor and student ID and keep course about the course. keep the tutor the same trying adding another table Tutor2Student. Put a ID, CourseID, StudentID...

Don't know if this helps but I think your problem now is you are not giving a value to a null result. You should use the Nz() function. Example Nz(field name,0) which will return a 0 for the null value of sum of invoices. As mentioned before the left join will return a row but no value = null...

you could use the open args style.. if you add the last argument to the docmd open form. then in the opening form in the OnOpen event use if Len(nz(me.OpenArgs,"")) > 0 then set you value here control = me.OpenArgs 'if you need to filter for one value then you use the same as vb...