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!

Register Log in
  • Congratulations gkittelson 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: *

  1. Computerpak

    Show Last Record with All Columns

    Thank you very much, it really worked. It was a good experience
  2. Computerpak

    Show Last Record with All Columns

    Following are the fields in the Table Inventory Item_id is autonumber Field ItemDetail ItemType Qty Price Remarks
  3. Computerpak

    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...
  4. Computerpak

    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
  5. Computerpak

    autoincrement in a querry

    Dear JoeMiller The procedure on those web pages is regarding, changing the autoincrement number in table not in querry
  6. Computerpak

    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

Part and Inventory Search

Back
Top