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 strongm 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: scubadunc
  • Content: Threads
  • Order by date
  1. scubadunc

    Search & Concatenate VBA

    Hi there Can anyone help. I have a database that has name and address details included. I need to find exact address matches, then combine the recipients names at the same address into one record/field with the following criteria: 2 people with the same surname at same address: Fname...
  2. scubadunc

    Truncate a text field into 3 text Fields

    Hi there I have a database that has an "Entity Name" field which in some cases is ridiculously long. I need to write a query or VBA function that will allow me to truncate only those records that have more than 35 chars into 3 fields, splitting at either an "&" or " " char. An example is...
  3. scubadunc

    1 to Many Relationship - Create New table merging contents

    Hi there I have a 1 to Many relationship between 2 tables where the primary key is a combination of the surname and address. So there is multiple people (parents, children etc) at the same address in my detail table. person1 129kensingtonst person2 129kensingtonst person1 30clasibrookrd...

Part and Inventory Search

Back
Top