Bem amigos preciso substituir em uma lstbox o valor sim/não por X
Estou usando a seguinte SQL.. mas esta mostrando X para todos Sim/Não
Como corrigir isso?
StrlstWayPointsGeral = "SELECT DISTINCTROW WayPoints.[ID], WayPoints.[Descricao] As UNIDADE, WayPoints.[Label] As ÁREA, " _
& "WayPoints.[Tipo] As TIPO, WayPoints.[Latitude] As LATITUDE, WayPoints.[Longitude] As LONGITUDE, " _
& "WayPoints.[LatMinDecimal] As LatMDecimal, WayPoints.[LongMinDecimal] As LongMDecimal, WayPoints.[Lat_Decimal] As Lat_Decimal," _
& "WayPoints.[Long_Decimal] As LongDecimal,iif(ChkBoxSul=0,' ','X') As S,iif(ChkBoxOeste=0,' ','X') As W," _
& "WayPoints.[X] As CartesianaX, WayPoints.[Y] As CartesianaY FROM WayPoints IN '" & StrPath & "'" _
& " ORDER BY Descricao"
Grato
Estou usando a seguinte SQL.. mas esta mostrando X para todos Sim/Não
Como corrigir isso?
StrlstWayPointsGeral = "SELECT DISTINCTROW WayPoints.[ID], WayPoints.[Descricao] As UNIDADE, WayPoints.[Label] As ÁREA, " _
& "WayPoints.[Tipo] As TIPO, WayPoints.[Latitude] As LATITUDE, WayPoints.[Longitude] As LONGITUDE, " _
& "WayPoints.[LatMinDecimal] As LatMDecimal, WayPoints.[LongMinDecimal] As LongMDecimal, WayPoints.[Lat_Decimal] As Lat_Decimal," _
& "WayPoints.[Long_Decimal] As LongDecimal,iif(ChkBoxSul=0,' ','X') As S,iif(ChkBoxOeste=0,' ','X') As W," _
& "WayPoints.[X] As CartesianaX, WayPoints.[Y] As CartesianaY FROM WayPoints IN '" & StrPath & "'" _
& " ORDER BY Descricao"
Grato