I'm a novice working with DAO and have a question that's been baffling me for most of the day.
A recordset is opened that is based on a table (On SQL Server) with default values (0) for the fields Day1, Day2, Day3 etc
But when looping through these fields they initially come up as Nulls so on the first iteration the calculation equals Null when it should be a value. Is there any way to get around this?
I'm running Access 2003 & SQL server 2000
Below is a portion of the code
A recordset is opened that is based on a table (On SQL Server) with default values (0) for the fields Day1, Day2, Day3 etc
But when looping through these fields they initially come up as Nulls so on the first iteration the calculation equals Null when it should be a value. Is there any way to get around this?
I'm running Access 2003 & SQL server 2000
Below is a portion of the code
Code:
Set rst2 = CurrentDb.OpenRecordset("tblTimeSheet", dbOpenDynaset)
With rst
Do Until .EOF
'some other code here...
Select Case Format(!OperationDate, "w", vbMonday, vbFirstJan1)
Case 1
rst2!Day1 = rst2!Day1 + !OperatorHours
Case 2
rst2!Day2 = rst2!Day2 + !OperatorHours
Case 3
rst2!Day3 = rst2!Day3 + !OperatorHours
Case 4
rst2!Day4 = rst2!Day4 + !OperatorHours
Case 5
rst2!Day5 = rst2!Day5 + !OperatorHours
Case 6
rst2!Day6 = rst2!Day6 + !OperatorHours
Case 7
rst2!Day7 = rst2!Day7 + !OperatorHours
End Select
rst2.Update