Doubts with the if in access 2013

Navigation
0

I want to put a condition in a DB in a table linking 2 data, one that adds variables put by the user, and another that decides what value is for example:

The options would be: Never 0-8 Sometimes 9-17 Almost Always 18-26 Always 27-36

And the user had 20 pts, then corresponds to "Almost always" what I do not know, it's like saying that automatically say in the cell what it was, since I have it manual and I want to put it automatic. (attached image if my explanation is not clear)

    
asked by Dave Pasos 01.11.2018 в 02:25
source

1 answer

0

You could occupy a VBA code in Microsoft Access. 

/*Variable "evaluacion" es la que transformamos en una evaluación escrita "evalEscrita"*/
Select Case evaluacion
   Case 0 To 8
      [evalEscrita] = "Nunca"
   Case 11 To 20
      [evalEscrita] = "A Veces"
   Case 21 To 30
      [evalEscrita] = "Casi Siempre"
   Case Else
      [evalEscrita] = "Siempre"
End Select
    
answered by 22.01.2019 в 12:48
Before Update Trigger SQL SERVER 2012 I need to put together a phpmyadmin SQL to list a table with the companies and contracts that I have to pay in the current month and that if I do not already pay the list