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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
RowNumber in a query
Ok, thanx. It works- Cryothic
- Post #6
- Forum: Microsoft: Access Queries and JET SQL
-
RowNumber in a query
Thanx, I looked at it, but this is VBA? I might be in the wrong forum then, but i'm using Delphi. I used this forum because I hoped that this problem could be solved using only SQL. Or am I wrong? Do you use these functions in the SQL-code? Greetings, Jeroen (Cryothic) Oostwouder- Cryothic
- Post #4
- Forum: Microsoft: Access Queries and JET SQL
-
RowNumber in a query
Hi, is it possible to place an extra field in a query with the rownumbers? So, if the usual result of the query would be: Name1 | Street1 | City1 Name2 | Street2 | City2 ----------------------- I would like: 1 | Name1 | Street1 | City1 2 | Name2 | Street2 | City2 I heard there is a ROWNUM...- Cryothic
- Thread
- Replies: 5
- Forum: Microsoft: Access Queries and JET SQL
-
SQL Datefield
Hi, I have a problem with a SMALL-DATETIME field in SQL SERVER. The fields are filled like this: 11/7/01 4:53:00 PM So, a date and a time in one field. But when I try to get all records from 11/7/01 I get none, because I don't know the times. So, WHERE datefield = '11/7/01' returnes 0...
