Search results

  1. G

    String Manipulation: Cleaning up address labels

    PROBLEM: String Manipulation "Cleaning up Mom's Christmas address labels" I need guidance on the best string manipulation functions (Instr, Left, Right) to cleanup my mother's Christmas address list of 300+ names. I have successfully imported the text file into Excel and exported to Access...
  2. G

    Export Palm contacts to Access for purge?

    Anyone know where I can find instructions for purging Palm TX contact files? I have tried to export to Access via CSV and Tab Delimited, but cannot get Access to import the either structure successfully from the Palm. I have over 10 years of Palm contact crud I would like to purge and figured...
  3. G

    Function for combining 2 string expressions?

    I am having a conversion problem combing the following 2 string expressions. Condition 1: Format([TestDate],'mmm dd", "yyyy') Condition 2: NZ([TestDate],"No Exam Found") I want to convert the dates to string values, and evaluate for Null fields, if Null display "No Exam Found."...
Back
Top Bottom