VB Help

[jjsand84]

I am making a program to schedule students to take a test. There should be no more than 10 students, "Max_Number", allowed to take the test at the one time. The "Available Slots" field should show the number of slots available, minus 1, when a student is scheduled for that "Date_ID".

[JetLinus]

Ok then! Fair enough...

[queball]

So what would you like help with?

[jjsand84]

I am trying to figure out the code to use so that 1 will be subtracted from the Max_Number when a student is scheduled for that Date_ID and the number should appear in the Available Slots field.

[Caesar2]

Use SELECT COUNT(*) in your SQL query?

[JetLinus]

Originally Posted by jjsand84

I am trying to figure out the code to use so that 1 will be subtracted from the Max_Number when a student is scheduled for that Date_ID and the number should appear in the Available Slots field.

lblAvailableSlots.Caption = Max_Number - 1

?

Originally Posted by Caesar2

Use SELECT COUNT(*) in your SQL query?

Seems no SQL is being used...

[Structural Integrity]

// select tests where more than 10 students are present
SELECT COUNT(*) AS StudentCount, test_ID, test_Date FROM Student_Test WHERE StudentCount > 10 GROUP BY test_ID, test_Date

// get the nr of open slots for every test... this should work in a JET database (MS Access). I don't know if your DB allows the 10-COUNT(*)
SELECT (10 - COUNT(*)) AS OpenSlots, test_ID, test_Date FROM Student_Test WHERE 1 GROUP BY test_ID, test_Date