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 bkrike 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: *

  • Users: David27
  • Content: Threads
  • Order by date
  1. David27

    Update Query

    I am updating our master client database with new client address information from our UPS shipments on a regular basis. Rather than enter the updates manually I want to merge the info. Duplicating the field structure in both databases is no problem. I want the query to only add a UPS entry to...
  2. David27

    Create unique record id

    I am trying to find a way to have Access 2000 create a unique record ID when record is updated based on customer name. ID would consist of first five characters of last name plus first three characters of first name plus middle initial of customer. Example: SMITHBILA. If ID length is less than...

Part and Inventory Search

Back
Top