si, ya probe con DisplayFormat
este es el query que hago
Código Delphi
[-]
Select C.Tdc, C.Doc, C.f_Doc, C.Hora, C.Aux, T.Descl As Trabajador, C.TOT, A.Descl As Producto
from (((tblConsumoC C
Left Join tblConsumoD D on (C.TDC = D.TDC and C.DOC = D.DOC))
Left Join tblTrabajador T on C.Aux = T.KOD)
Left Join TblArticulo A on D.KOD = A.KOD)
Where C.f_doc >= '01/05/2011' and C.f_doc <= '17/05/2011'
Order by C.AUX, C.f_DOC
quiza en el query deba truncar algo?