var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Update puzzle
I have a query that gives me results for StudentID and Other.
I need to take these results and do the following.
Go to Detentions table and update the first Null values in the Status
field to "Oth" for the StudentIDs mentioned.
So in Detentions table:
I could do this in an extremely complicated way but am looking for an
elegant solution. Would anybody have any suggetions?
RE: Update puzzle
This may not be elegant but it's not too complex. This is in quick, rough pseuodcode.
For i = 1 to query.recordcount
ID = query!StudentID
OpenRecordset (Detention, where StudentID = ID and IsNull(Status))
For n = 1 to query!Other
Detention!Status = "Oth"
Determine if you need to order the Detention recordset in any way. Let me know if you need any more help.