Search results

Thank you very much for your additional explaination... I did this again without the wizard, and this is what I've come up with so far. I believe that my current problem is how to tie (( filter )) the course hours from student 23 to the course hours for only student 23. It's still showing the...

I think that I'm misunderstanding when you said 'bind' -- I see where it's bound to column 1 in the properties box. When I add the list box, I get these two ( pictures included) questions that I don't know how to respond to that I think could be the source of my issues ?

At our school, we all ready have an established FAME ID and Student ID, which is why I came up with the term System_ID. For clarity, I changed the name ID in the students table to System_ID , which I do believe makes things easier to understand. I had an error when I made this change, so I...

I've tried this, ( at least I think so... maybe went overboard a tad ?) Once again, I've attached pictures. It seems as though it does show CDL hours and Oil hours, but it shows the same hours for every student and the only way I can edit these numbers is directly in the table it's self...

Could be normalized like CourseName , CourseHours CDL, 80 Heavy, 160 Oil, 40 Where these would all be separate records, and I could make the CourseName a separate table. My question here is, how could I change my form so that the end user would be able to easily see how many hours this...

Thank you for your help and patience with me :D

I've been very careful with data entry to either make the entry null, (or in one of my above examples, I left the entry completely out), so as to not have the undesirable result you mentioned.

I would like to thank everyone here for opening my eyes. I thought I was doing a good job of normalizing, but obviously I wasn't. Thank you for pointing out the errors of my ways without being condescending or hurtful. It's greatly appreciated. I'm working on the Students table now.

Occasionally, the student just observes and gets no grade, but they do get credited for the time that they spent, without a grade. That is, however, rare. Most of the time, all 10 records are logged with the rare exception that the student didn't shift (automatic truck), or didn't go on the...

Thank you very much... Now I'm going to have to wrap my mind around how to make a form to make that happen. Student, Element, Grade 1, Starting-Stopping-Braking, 3.5 1, Sharing_the_road, 3.5 1, Steering_Turning, 3.5 1, Lane_Changing_Passing, 3.5 1, Vehicle_Spacing , 3.5 1, City_Driving, 3.5 1...

I've read these many helpful posts and links and seen several videos on normalizing.... what, specifically, am I missing ?? I've attached a picture of our 'road card'. Here, you can see that there are 10 graded elements which, when averaged together, make up the final 'Grade' for that...

I've renamed some of the fields so that they make more sense. I can see where I could break the Students table more.

Even if I rename the fields as you described, I would still have the SAME issue that I have here.

When I first took over this job, I created ad-hoc spreadsheets to help me with grading and keeping track of our student's road hours. I quickly realized that I needed to use a database, so I've been on working that. All of my entries that you're seeing here was entered directly in a Access...

I do have a database, and my fields are normalized. Perhaps I'm just doing a bad job at explaining myself. I apologize for that. :eek: Our road scores are divided between 10 different elements and the final score is the average of the above mentioned elements. I simply renamed them A1-A10...

I'm trying to calculate the number of columns that are not null so I can accurately calculate the average of our student's grades per record. I've included an attachment from the query. Sometimes I get numbers that don't make any sense to me at all. The expressing I used in the Not_Null...

Thank you for your assistance. As I've worked through this, I made the following revision(s), which I believe is what you mean by 'binding' a field. I revised my queries so that they sum the hours and scores separately before bringing them into my form. To get my totals, I created a query...

[SOLVED] Sum on subform #Error I've been searching the forum for something similar to the problem that I'm having without any luck, so I'm going to do my best to explain my problem and see if anyone can please help. I started my project with the students database template that comes with...

Hello. I am Terry Mullins from the Cleveland, Ohio area. I currently work as the Training Manager / IT Manager for Great Lakes Truck Driving School. I have several years of programming experience using Dbase, Q&A,MySql as far as database languages goes. I've also worked with VBA and PHP...