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 wOOdy-Soft 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 Computerpak
-
Show Last Record with All Columns
Thank you very much, it really worked. It was a good experience- Computerpak
- Post #5
- Forum: Microsoft: Access Reports
-
Show Last Record with All Columns
Following are the fields in the Table Inventory Item_id is autonumber Field ItemDetail ItemType Qty Price Remarks- Computerpak
- Post #3
- Forum: Microsoft: Access Reports
-
Show Last Record with All Columns
I am trying to retrieve the last record inserted into an Access database. I have created a field in the table that uses the AutoNumber function to create a new ID for each record. When I try to retrieve this last record by using "Last" function and setting TOP value =1, all I can get...- Computerpak
- Thread
- Replies: 4
- Forum: Microsoft: Access Reports
-
autoincrement in a querry
My email address is amerhabib@computerpak.com Please send me a copy of that sample database Regards Amer Habib amerhabib@computerpak.com- Computerpak
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
autoincrement in a querry
Dear JoeMiller The procedure on those web pages is regarding, changing the autoincrement number in table not in querry- Computerpak
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
autoincrement in a querry
In a querry I want the records to start from a number other than 1 and then autoincrement by 1. When we click on to run the querry, a screen should popup asking what number you want to give to first record and then autoincrement by one. I need a SQL syntax for this. Could someone help me- Computerpak
- Thread
- Replies: 4
- Forum: Microsoft: Access Queries and JET SQL
