Kod:
SELECT Coax_Yapi_Izole.Tel_Sayisi_Kumesi, Coax_Yapi_Izole.Tel_Sayisi, Coax_Yapi_Izole.Tel_Sayisi_Kumesi AS A, IIf([A]=0,([A]*2),IIf([A]=1,([A]*5),IIf([A]=7,([A]*13),IIf([A]=19,([A]*28))))) AS Sonuc
FROM Coax_Yapi_Izole;
SELECT Coax_Yapi_Izole.Tel_Sayisi_Kumesi, Coax_Yapi_Izole.Tel_Sayisi, Coax_Yapi_Izole.Tel_Sayisi_Kumesi AS A, IIf([A]=0,([A]*2),IIf([A]=1,([A]*5),IIf([A]=7,([A]*13),IIf([A]=19,([A]*28))))) AS Sonuc
FROM Coax_Yapi_Izole;
Bu Konudaki Yorumlar |
Cvp: sorgu!!! - Yazar: Subco - 27/05/2010, 14:56
Cvp: sorgu!!! - Yazar: Puletin - 27/05/2010, 14:59
Cvp: sorgu!!! - Yazar: POWER - 27/05/2010, 15:00
Cvp: sorgu!!! - Yazar: Puletin - 27/05/2010, 15:01
Cvp: sorgu!!! - Yazar: Subco - 27/05/2010, 15:05
Cvp: sorgu!!! - Yazar: fmc - 27/05/2010, 15:21
|