How to change course cost without affecting the values of the previous students

[Wabamdo]

Hi guys,I am developing a school database system fees module in Microsoft access,how will i be able to set up my tables such that i will be able to change courses cost without affecting earlier records that depended on the COST field in the courses table.


Thank you in advance.

[Homegrownandy]

I just did a bit of looking and came across this:

Private Sub txtSaleDate_AfterUpdate()
If IsDate(Me!txtSaleDate) Then ' see if user entered a date
  If IsNull(Me!txtDeliveryDate) Then ' don't stomp on existing data
   Me!txtDeliveryDate = DateAdd("d", 14, Me!txtSaleDate)
  End If
End If
End Sub

I'm sure this can be adapted for your needs.

Early dates = old value
dates after x = new value

not an exact answer but it might help you make some progress.

[LaughingBull]

Private Sub CurrencyCourseCost_AfterUpdate()
Select Case CurrencyCourseCost
Case x = Me!CurrencyCourseCost 'this makes x = to the existing course cost
Case x = x + [Enter raise in Course Cost] ' this should give you a prompt
to enter the rise in course cost and add it to the existing cost for new cost
End Select

End Sub

[orange]

See the info in this post