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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Something difficult
Yes that's the problem. My query must show the row which its [creation_date] is the last of one [Asunt] and the [Asunt] can't be in the state Autofactur. I mean, I'm trying to do a list of pending task, and when a [Nº Siniest] is Autofactur it supposed to be done and it shouldn't be listed...- handsomed
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
Something difficult
This is the order in the table. I created an autonumber field called IdNumber, so for example '05/12/2008 11:55:00 Valoración aceptada' would be IdNumber=7 and '05/12/2008 11:55:00 Autofactur' would be IdNumber=8, I think- handsomed
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Something difficult
I have this query: SELECT DISTINCT Q.[creation_date], Round(Now()-Q.[creation_date],0) AS Diferenc, Q.[Nº Siniest], Q.Asunt, Q.Usu, Q.Obs FROM [HISTORIC] AS Q WHERE (((Q.[creation_date])=(SELECT MAX([creation_date]) FROM [HISTORIC] As T WHERE T.[Nº Siniest] = Q.[Nº Siniest])) AND ((Q.Asunt) Not...- handsomed
- Thread
- Replies: 4
- Forum: Microsoft: Access Queries and JET SQL
