Taxidriver
Programmer
I build a datagrid using
Adodc1.RecordSource = "SELECT DettaglioLavoriOre.idDettaglio,DettaglioLavoriOre.IdTipo as C200_C201 FROM etc etc..."
the data in IdTipo can be 0 or 1 or 2.
I would prefer to have C200 if the value is 2 and C201 if the value is 1, displayed in the datagrid.
Is it possible to do it via code?
Adodc1.RecordSource = "SELECT DettaglioLavoriOre.idDettaglio,DettaglioLavoriOre.IdTipo as C200_C201 FROM etc etc..."
the data in IdTipo can be 0 or 1 or 2.
I would prefer to have C200 if the value is 2 and C201 if the value is 1, displayed in the datagrid.
Is it possible to do it via code?