Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by arlelua
-
Unkown Date error in Query
Dear SkipVought and PHV, thanks for your answer, but there is not a problem with QOUTES, sorry if I didn´t put it in my first message, and also don´t put the assignation to the variable. But this aren´t the problem I try to do this inside Acces 2007 (Create a Query) and the problem persists...- arlelua
- Post #6
- Forum: Microsoft: Access Queries and JET SQL
-
Unkown Date error in Query
Thank´s for yout time SkipVought let me tell you that I´m using access 2007, and this query is from a program develop in VB 6.0, the values are in format mm/dd/yyyy and this query works fine with this values: ddFecha_Inicio = 1/1/2011 ldFecha_Fin = 1/31/2011 But when the values...- arlelua
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Unkown Date error in Query
I have the next query SELECT tbfacturas.dsNumeroFactura, tbfacturas.psCliente, tbClientes.dsNombreRazon, tbfacturas.ddFecha, SUM (tbfacturas.dsSubtotal) as Subtotal FROM tbFacturas INNER JOIN tbClientes ON tbFacturas.psCliente = tbClientes.psCliente WHERE (tbFacturas.ddFecha >= #" &...- arlelua
- Thread
- Replies: 5
- Forum: Microsoft: Access Queries and JET SQL
