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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: GoneAccessCrazy
- Content: Threads
- Order by date
-
Only the date in a datetime
Is there a way to select only the date of a datetime column, I was using the left(date1,10) but when the system date format is other that MM/dd/yyyy y end up getting part of the time. e.g. Select left(date1,10) as dateBegin, right(date1,8) AS hourBegin ... when date is MM/dd/yyyy I get...- GoneAccessCrazy
- Thread
- Replies: 8
- Forum: Microsoft: Access Queries and JET SQL
-
putting a 0 when something is null (empty)
Hi, I dunno if this thing is possible... I first have 2 queries and their results... ****QueryRent: SELECT Cliente.IdCliente, Cliente.Nombre, Cliente.ApePat, Cliente.ApeMat, Sum(Alquiler.MontoTPagado) AS MontoPagadoA, Cliente.MontoDeuda FROM Cliente INNER JOIN Alquiler ON Cliente.IdCliente =...- GoneAccessCrazy
- Thread
- Replies: 8
- Forum: Microsoft: Access Other topics
