samedi 1 juillet 2017

MS Access 2003 Is it possible to get the following result in the report?

In MS Access 2003 I have a report with 4 possible scenarios

1.possible scenario: If (Me.Ocjena1 = 2 Or 3 Or 4 Or 5) And (Me.Ocjena2 = 1) And IsNull(Me.Ocjena3) Then Me.Konacna_ocjena = 1 End If

2.possible scenario If (Me.Ocjena1 = 2 Or 3 Or 4 Or 5) And (Me.Ocjena2 = 2 Or 3 Or 4 Or 5) And IsNull(Me.Ocjena3) Then Me.Konacna_ocjena = (Me.Ocjena1+Me.Ocjena2) /2 End If

3.possible scenario If (Me.Ocjena1 = 2 Or 3 Or 4 Or 5) And l(Me.Ocjena3 =1) and (Me.Ocjena3 = 2 Or 3 Or 4 Or 5) Then Me.Konacna_ocjena = (me.Ocjena1+me.Ocjena3) /3 End If

4.possible scenario If (Me.Ocjena1 = 2 Or 3 Or 4 Or 5) And IsNull(Me.Ocjena2) And IsNull(Me.Ocjena3) Then Me.Konacna_ocjena = Me.Ocjena1 End If

Sometimes is included all 4 scenarios. With this code work max 2 scenarios but 2 rest not working... Where am I wrong?

Aucun commentaire:

Enregistrer un commentaire