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 John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Recordnumber
the problem is that it's not enough in the report, I have to calculate with this column. evrey visit cost 1$ ,but the second_visit / month it's free of pay, and not every day it will come, etc. select * Visitors_table join visit_records; # * visitor entry -------------------------- 1...- szotto
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Recordnumber
How can I show in query (or form) the record number ? ( the autoincrement filed can have some holes depend if I was deleted some records) SELECT id,name FROM mytable ORDER BY id DESC ; # id Name --------------- 1 5 Beta 2 3 Alpha 3 1 Teta SELECT id,name FROM mytable ORDER by...- szotto
- Thread
- Replies: 5
- Forum: Microsoft: Access Queries and JET SQL
